VB IMport

Taftheman

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

Nov 9 '06 #1

scripto

The problem most likely is user permissions on the DTS package. Try changing the owner of the DTS package so everyone???? can execute it.

Nov 9 '06 #2

Taftheman

The problem most likely is user permissions on the DTS package. Try changing the owner of the DTS package so everyone???? can execute it.

How would you do that, as i can't see anything to do with permissions on the DTS package

Nov 10 '06 #3

scripto

easiest way - open the DTS package and save it again.
Hopefully, if you belong to a group login, (and you should) anyone in that group will have permissions to run the package. Then adding or removing users from that group will allow you to control who has permissions to run the DTS package.

Nov 10 '06 #4