November 20, 2006 at 2:52 am
Hi,
I posted a similar item last week which I answered in error so apologies if anyone picked up on it incorrectly.
I have an Access 2003 app which has been implemented to call a DTS package in SQL2000 but now it needs to call the equivalent SISS package in SQL 2005. The code I have used is as follows....
'>>start of call
Dim oPkg, oStep, sMessage, bStatus
Const DTSSQLStgFlag_Default = 0
Const DTSStepExecResult_Failure = 1
Set oPkg = CreateObject("DTS.Package")
oPkg.LoadFromSQLServer "Svr\Instance", "User", "Pwd", 0, , , , "DTS Package name"
oPkg.Execute
Set oPkg = Nothing
'>>end of call
I've tried various attempts and the only thing I have found is that SISS only allows windows authentication and I also get an error message stating that "The specified DTS package (.............) does not exist"
Also, do I need to install anything on the client for Access to recognise the new object model for SISS? That is when I am creating the object in Access.eg. Set oPkg = CreateObject("SISS.Package")
If there is anyone out there similar experiences or can help I'd appreciate it.
Thanks in advance,
Eamon
November 22, 2006 at 3:30 pm
Hi Eamon, I don't see a package name anywhere. What is the name of the package your are attempting to call?
November 23, 2006 at 1:14 am
Hi dw,
the call to the currenrt DTS package is
oPkg.LoadFromSQLServer "Svr\Instance", "User", "Pwd", 0, , , , "DTS Package name"
oPkg.Execute
with "DTS Package name" been the name.
This isn't actually that urgent anymore as I have absorbed some of the required functionality back into Access leaving only calls to required SP's which is straight foward.
That said it would be nice to know how to do it.
Eamon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply