DTS packages

[sineados]

Hi,

Does anyone know if you can pass in a filename for a DTS package. I did the import and saved the package but I want to run the same procedure on different filenames. When I did the import I had to select the filename.At the moment I have three different packages even though the structure of the excel file is the same

thanks,
Sinead

 

[philhege]

What I did to handle this situation: I saved my DTS package into a Visual Basic file, and then created a VB app from the exported code that would accept the filenames as parameters. Then I run the VB from the file system (or you could call it with xp_cmdshell if you'd like).

HTH,

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Eschewing obfuscation diurnally.

 

[SQLDenis]

Use a global variable and use SQL to populate it (I assume the filename is different everyday depending on the date)
have a template file
copy the content of the file you want to process into the template file by using the File System object
process the file
clear the template file

or chase the source file name

check out

http://www.sqldts.com/default.aspx?292

and

http://www.sqldts.com/default.aspx?231

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/