467,151 Members | 900 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,151 developers. It's quick & easy.

VB IMport

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
  • viewed: 3175
Share:
3 Replies
scripto
100+
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
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+
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.

Similar topics

reply views Thread by Stian Søiland | last post: by
reply views Thread by Vio | last post: by
reply views Thread by John Roth | last post: by
5 posts views Thread by Steve Holden | last post: by
4 posts views Thread by Bruce W. Roeser | last post: by
7 posts views Thread by Ron Adam | last post: by
5 posts views Thread by W. Watson | last post: by
9 posts views Thread by rsoh.woodhouse@googlemail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.