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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2006-06-23 : 11:06:25
|
| HiI am loading a text file into my DB tables. This part is easy for me through a SP but the problem is how can i pick up the right file to load coz every time the file name will be changing. Here the load is done by the user its not automated. when the user clicks on load file the SP which fires the load process.Is there a way like...If the user know the file name to load, he will be sending the file name to the SP(load process), then the SP picks up the given file name. How can i do this? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-23 : 12:03:12
|
| If you're doing it via an sp then why use dts?Use bulk insert and it should be simple as you can build the command in the sp with the filename.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Load