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-29 : 22:46:08
|
SIRAJ writes "I need some DTS help.
I am trying to create a DTS package to lookup for flat files on a server and import all those files into SQL tables. The number of files varies each time. I just cannot figure how to create a package with looping capabilities within the steps.
I created a source connection for flat files. I have a dynamic property to change the source files. I have a activex script which finds all the files with .ibm ext and loads the filename into a table. I have a transfer task which transforms the data from flat files into table.
I just cannot figure out how to configure the transform task to transform all the files to the same destination table one by one.
Any help will greatly appreciated..
Thanks
Siraj Kasmani" |
|
|
|
|
|
Need DTS help