How to specify a source file name using a parameter in DTS

[mariayx]

Hi all,
My ActiveX script loops on file names in a file directory and passes file name in a parameter one at a time as input source file for process in DTS package instead of specifying a fixed file name. Can anyone tell me about the syntax on how to pass the parameter for the file name? Thanks.
mariayx

 

[mariayx]

Hi all,
Is there any guru out there that can help? I could not figure out how to put a variable as file name at step Text File(Source) in a DTS package. The previous step in the package is an Active X script which defines the variable.
Appreciate any help!
-mariayx

 

[JohnDTampaBay]

The quickest answer, I think, is to add a Dynamic Properties task between the ActiveX script and the data import. The task will assign the global variable value to the source filename property of the connection. I'm sure you can set this property directly from the ActiveX script, but I don't know the exact syntax. You could try

http://www.sqldts.com

for possible assistance. Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.