I have created DTS Local Package for Migration of data from Text file to
Database Table. This is working fine. I change the file name often times when
I execute the DTS Package, for this purpose I have to change this DTS with
parameter so kindly guide me how can I change my this DTS Package with
Parameter for change the text file name for migrating of data.


Farhan Iqbal

You can start by checking the following article:
How can I change the filename for a text file connection?
http://www.sqldts.com/default.aspx?200
I'm not clear on how or where you want to use a parameter
for the text file name but one option you can use with the
above is to use a global variable for the file name. You can
execute the package with the global variable switch /A used
with dtsrun and this could be the filename.

-Sue

On Tue, 22 Mar 2005 04:05:03 -0800, Farhan
<Farhan (AT) discussions (DOT) microsoft.com> wrote: