Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
makimark
Starting Member
34 Posts |
 Posted - 2003-06-30 : 05:44:46
|
| HiI need some pointers on passing a filename as string to a DTS package. The file comes from an FTP dir and needs to be processed by the DTS package. The problemo is that the filename changes.In my program the user has to "browse" for the file and this filename then has to be passed to the DTS package for processing. The file structure will stay the same though. Thanks |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2003-06-30 : 08:06:54
|
| well i have some thign like this before.. loading data from filesu need to save ur package as vb module file...and in ur code(if u are using vb.. ) u can pass the file name as parameterdo the following changes1. change private main to public main.2. add a parameter to ur main3. replace the file name to variable(parameter)and in ur ui u can call ur main (filename) that shd help u======================================Ask to your self before u ask someone |
 |
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-06-30 : 19:51:28
|
| first step is to make the package use a global variable for the filename.then you can use DTSRUN.EXE to execute the package. DTSRUN.EXE lets you pass parameters that correspond to global variables in the package being executed. So in other words, you can pass the filename to the package from the command line. |
|
|
|
|
|
|
Passing filename to DTS