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-03-08 : 22:21:40
|
Uvaraj writes "I am using WinNT 4.0 to connect to SQL server 7.0 . I want to transfer the content of a Text file to Sql server Table and vice versa. Since I need to convert the Txt file to Access database table also I can not use BCP. I want to do this programmatically through DTS.
The columns of data in the Text file varies and hence I have to dynamically specify them through stored procedure input parameters.
I tried using DTSPKG.DLL in VB to do this but I am getting "File access denied" error and MSDN says "Using Named pipes" will resolve this. But still I am not able to use that DTS package DLL through VB for BulkInsert Task. But I am able to execute SQL statements through ExecuteSQLTask object.
I would like to know if it is possible to specify the DTS datasource and datadestination properties etc through stored procedures or in other words how should I use stored procedure and DTS to programmatically to serve my requirements." |
|
|
|
|
|
Invoking DTS properties through Stored Procedure