Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Changing the source file of a DTS package using global variables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-03 : 07:46:33
Thavash writes "Hi

I've got a DTS package which reads a text file into a table.

What I want to do is pass a string to the DTS package containing the location of the file to be uploaded, so that I can write an ASP page where the user selects a text file on his hard drive and it's uploaded into the table.

How would I do this ( can DTS Global Variables help here ? )

OS : XP
SQL Server 2000 SP3


Thanks in advance
Thavash"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-07-03 : 12:30:24
http://www.sqldts.com/default.aspx?6,101,200,0,1

Jay White
{0}
Go to Top of Page
   

- Advertisement -