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 - 2001-04-02 : 13:10:50
|
Dave Vick writes "I have an SQL table that receives its data from multiple dBase files. The dBase files are ftp'd to a directory on the server and then on a regular schedule I need to get all of the data from all of the files into the SQL table. I have a data pump that does this but I want to include some sort of looping mechanism to get ALL of the dbf files in the directory. I was trying to get this to work using an ActiveX script in the DTS package but can't seem to get it right. I already have an ActiveX script that transfers all of the files from the directory they are uploaded to to a temporary directory where they are held until moved into the SQL table. Then I have another script that will run on the completion of the first, this one will loop through all of the files and rename them to a generic name so the data pump can act on them. The problem is how do I tell the data pump that a file is ready to be tranfered? I can set a global variable when the file is renamed but how does a data pump check the value of the variable? Or is there another way to do this?
I'm using SQL Server 7.0 on an NT 4 OS.
Thanks
Dave " |
|
|
|
|
|
multiple source tables into one SQL table