Hi All, I got the following error executing a scheduled DTS package that use a "Copy SQL Server Objects Task" task: SQL: Error = -2147221504 (80040000) Invalid OLEVERB structure Can u plz advice about this issue... A quick reply is appreciated. Thanks in advance GK
Can you just execute the package (not the scheduled job) and make sure you are getting the same error? Roji. P. Thomas http://toponewithties.blogspot.com
If you're using a DTS to copy data from one server to another, check the script path in the "Copy SQL Server Objects" task.The default path on a 32-bit system is Crogram FilesMicrosoft SQL Server80ToolsIf the DTS is created on a 64-bit machine the path will most likely be Crogram Files (x86)Microsoft SQL Server80ToolsRemove or add the " (x86)" as required. Or just use another valid path.This fixed it for me.Ben
