July 2, 2008 at 3:58 pm
This DTS has been running for sometime, it basically copies tables to a new monthend database, I checked the scripting path and looks good, the DTS did not create a file in this directory, any ideas
-Peter
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147221504 (80040000)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error Detail Records:
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5700
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Error source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_2
DTSRun OnError: DTSStep_DTSTransferObjectsTask_2, Error = -2147220413 (80040443)
Error string: Unable to connect to source server for Transfer.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5700
Error Detail Records:
Error: -2147220413 (80040443); Provider Error: 0 (0)
Error string: Unable to connect to source server for Transfer.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5700
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Error source: Microsoft SQL-DMO (ODBC SQLState: 08001)
Help file: SQLDMO80.hlp
Help context: 700
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_2
DTSRun: Package execution complete.
NULL
January 21, 2009 at 8:59 am
I am having this same issue moving objects from one sql server 2005 instance to another. No answers to this?
Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Invalid OLEVERB structure (Microsoft Data Transformation Services (DTS) Package (80040000): Invalid OLEVERB structure ) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on Server.Databasename.DP2'. ) Step Error code: 80040000 Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100
¤ §unshine ¤
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply