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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-15 : 08:18:17
|
| John writes "I am trying to import as series of text files to a SQLSERVER 7.0 database from different loactions on a LAN (Win NT). To do this I would like to use a SQLSERVER job that will execute overnight so the data is ready for analysis on the VB front end in the morning.I have set up a DTS package to do the import loop. This gets the filename dynamically from a table and sets it as the text datasource as below, then processes the next file using a loop in the package steps.set oConn = DTSGlobalVariables.Parent.Connections("Connection1")oConn.datasource = DTSGlobalVariables("gsFileName").ValueThis works fine for the first file however when the 2nd and subsequent files reach the import step the data from the first file is imported again.Using msgbox I can see that the gsFilename variable is updated correctly in the pre import step!!!!!" |
|
|
|
|
|
DTS Activex 'Datasource' loop