October 8, 2002 at 2:32 am
Hi!
We have a DTS package designed in SQL2K running smoothly. However, when we implement this package in SQL7, we are encoutering this error:
"Multiple-step OLE DB operation generated errors"
This is being encountered in one of our activex step. Below is the complete code of the activex step that's encoutering this problem.
Function Main()
'Declare Variables
Dim oPKG
Dim oSourceConn, oTargetConn
' Get Package Object
Set oPKG = DTSGlobalVariables.Parent
' Get Source Connection Object
Set oSourceConn = oPKG.Connections("SourceDB")
Set oTargetConn = oPKG.Connections("TargetDB")
'Assign New Server from INI File
oSourceConn.DataSource =DTSGlobalVariables("gv_SourceServer").Value
oSourceConn.UserID = DTSGlobalVariables("gv_SourceLoginID").Value
oSourceConn.Catalog = DTSGlobalVariables("gv_SourceDBName").Value
oSourceConn.Password = DTSGlobalVariables("gv_SourceLoginPasswd").Value
oTargetConn.UserID = DTSGlobalVariables("gv_TargetLoginID").Value
oTargetConn.Password = DTSGlobalVariables("gv_TargetLoginPasswd").Value
oTargetConn.DataSource =DTSGlobalVariables("gv_TargetServer").Value
oTargetConn.Catalog = DTSGlobalVariables("gv_TargetDbName").Value
Main = DTSTaskExecResult_Success
End Function
Your help will greatly be appreciated. Thks alot in advanced.
Rgds,
Wally
October 8, 2002 at 10:40 am
I don't know if this will help or not, but we got a similar error because of SQL Server version incompatibilities with using client tools from version SQL Server 7.0 SP 2 to modify a DTS package that is executed by SQL Server 7.0 SP 3 or SQL Server 2000.
Until I discovered the incompatibiliy problem I would simply go to the SQL Server where the DTS package is saved at and reset all the connections and then it would work.
I can't say for sure if this is your problem or not as I am not familiar with the code you are using in your active X task.
Robert Marda
SQL Server will deliver its data any way you want it
when you give your SQL Programmer enough developing time.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
October 8, 2002 at 6:26 pm
I don't see where it is related based on the code here but the only other time I have seen this is when some failure occurrs within the query usually associated with a typo or other mistake.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply