VBScript SQL Bulk Insert语句

Question

我有一个简单的sql bulk insert语句，它在sql mgmt studios中工作得很好。我正在尝试从一个.vbs文件运行sql命令。这是我的vbscript代码。它会一直转到msgbox并显示消息。它没有显示任何错误，所以看起来正在完成，但是数据库中的表是空的，所以没有导入数据。我遗漏了什么？

option explicit

Dim objConn
Dim objRS
Dim strSQL
Dim ConnectionString

Dim fso             
Dim objArgs

ConnectionString = "Provider=SQLOLEDB;Server=mtgops047-db006;Database=interlinqe3;Trusted_Connection=yes"

Set objConn = CreateObject ("ADODB.Connection")
Set objRS = CreateObject ("ADODB.RecordSet")
Set fso = CreateObject("Scripting.FileSystemObject")

objConn.Open ConnectionString

strSQL = "delete from Settlement_Import_Data"
strSQL = strSQL & " BULK INSERT Settle_Import_Data"
strSQL = strSQL & " FROM '\\server\sharedfolder\importdata.txt' with"
strSQL = strSQL & " ( FIELDTERMINATOR =',', ROWTERMINATOR = '\n')"


Set objRS = Nothing
objConn.Close
Set objConn = Nothing
MsgBox ("Update Complete!") 
WScript.Quit()

Answer 1

为您的delete语句调用一次objConn.Execute()并为您的bulk insert语句再次调用它解决了这个问题。谢谢!