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 |
|
hagitz
Starting Member
2 Posts |
 Posted - 2002-01-23 : 04:31:00
|
| I want to transfer the content of a Text file to Sql server Table throught DTS.The Problem is , that the Source Data File location should be dynamically allocated 1000 times... (The same file name in 1000 different folders.)Is there any DTS task that can perform this dinamically files sepcification? if not how can it be done otherwise?Thanks. |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-01-23 : 05:10:09
|
| if i am not wrong u want to provide a dynamically path of the source file..... if so if u are working SQL 2000...design a package source and targetand save u package as visual basic moduleu can open module in vb and pass the path dynamically ....hope this will help ubyeAsk to your self before u ask someone |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-23 : 05:37:15
|
| Why do you want to use DTS?Probably easier and safer to just code a bulk insert statement in a stored proc with the path as an input parameter.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
specify Bulk Insert Task dynamically