By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,059 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

VB IMport

P: 93
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
Share this Question
Share on Google+
3 Replies


scripto
100+
P: 143
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

P: 93
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
100+
P: 143
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

Post your reply

Sign in to post your reply or Sign up for a free account.