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-08-06 : 23:40:18
|
| Peter writes "HiI can load a text file into an SQL SERVER Table using a DTS package but as I need to load about 100 text files into one SQL Server table I feel it would be better to do this using an Active X script task.I cannot use a BULK INSERT Statement as I do not have SysAdmin permissions so I thought I could do it using statements like :DTSDestination("ColA")=DTSSource("Col1") but I do not know how to do this (I Cannot figure out how to specify a text file as the source using VBScript). I am obviously on completely the wrong track.Can someone tell me if it is actually possible to write an ActiveX Script which loads a text file into an SQL Server table and if so, show an example which I can later modify to loop through the 100 or so files that I need to load?Thanks for your helpPeter" |
|
|
|
|
|
Using an ActiveX Script in DTS to load Data files