Hello,
I want to process/Import a text file using DTS and i want to send the file
name at run time.. is it possible to do
OR i have to use vbscript to create package at run time

Thanks

You can either use a global variable and pass the value in via DTSRUN.EXE,
or you can use an INI file in conjunction with a Dynamic Properties task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kailux4" <kailux4 (AT) discussions (DOT) microsoft.com> wrote

Hello,
I want to process/Import a text file using DTS and i want to send the file
name at run time.. is it possible to do
OR i have to use vbscript to create package at run time

Thanks