Change path in DTS..?

[kenjoswe]

Hi all,

If I open the package from my home computer the filepath relates to the path
on the local client so therefore I cannot change the path for the
SQL-server.

How can I edit the path to a Textfile datasource for SQL-server in a
DTS-package from a remote computer?

Can I edit from Query Analyzer?

/Kent J.

 

[nowayout]

Go to Enterprise manage and then go to DTS and then open your DTS package and thne change the connection 1 data source to text source

 

[kenjoswe]

nowayout,

Yes I know.
But is there a way to connect a textfile from a FTP-area
ftp://abc.test.se/Data/Load/Test.txt
... and import it directly to a SQL-table


/Kent J.

 

[bs26]

use dynmaic properties to set the path