Hi all
I have made an import function using vb6, I get data from MS Access then put it into sql server 2000, however this is done by users so i have created a DTS package in sql server 2000. And coded it so users can execute when they liek using vb6. The problem is it works on my computer, I have sql tools, but it won't work on the users computer, we give them connection to slq server 2000. Could I be making a mistake on the code that executes this package. The following is the code
Set oCN = oPKG.Connections.New("SQLOLEDB")
oCN.ConnectionProperties("Integrated Security") = "SSPI"
oCN.ConnectionProperties("Persist Security Info") = True
oCN.ConnectionProperties("Initial Catalog") = gvCatalog
oCN.ConnectionProperties("Data Source") = gvSource
oCN.DataSource = Text1.Text
oPKG.LoadFromSQLServer gvSource, "", "", "256", "", "", "", strDTS
oPKG.Execute 'Execute Exporting data into SQL Server Temp Table
oPKG.UnInitialize
I have also tried doing it in one line but nothing seems to be working
Note:
catalog = database name
gvsource = server
strdts = name of dts package
|