SQL Server Performance Forum – Threads Archive
DTS Package fails with error – Invalid OLEVERB str
Dear All,<br /><br /> <br /><br />I have a DTS Package that transfers SQL database objects (Tables & Constraints) from one server to another server using Copy SQL Server Objects Task. I am getting an error as below -<br /><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:<b>Invalid OLEVERB structure</b><br /> (Microsoft Data Transformation Services (DTS) Package (80040000): Invalid OLEVERB structure<br />) (Microsoft SQL-DMO (80004005): [SQL-DMO]CreateFile error on ‘<servername>.<tablename>.DP2′. )<br />Step Error code: 80040000<br />Step Error Help File<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />qldts80.hlp<br />Step Error Help Context ID:1100<br /><br />Please let me know if anybody has any clue to this error. I have several Copy SQL Server Objects Tasks in the same DTS package. The package has been configured to run 2 tasks in parallel at any point of time. Each time the package fails to tranfer different set of SQL objects.<br /><br />Thanks in advance,<br /><br />Suresh<br />Refer to this KBAhttp://support.microsoft.com/kb/283811/en-us fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>