August 5, 2002 at 12:03 pm
When I schedule a DTS package and execute it from the job it fails, but when I choose 'Execute Package' when right click on the package name it works just fine.
The error while executing a job says:
Error string: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Error source: Microsoft OLE DB Provider for SQL Server
Maybe somebody had this problem and knows how to get around it?
Thanks!
August 5, 2002 at 2:28 pm
Are the permissions that SQLServerAgent the same as the user logged in when you execute the package directly from within DTS?
hth,
Michael
Michael Weiss
Michael Weiss
August 5, 2002 at 3:27 pm
I have got the same problem. Follow the instructions below to fix it. Good luck.
1.Get information from DTS related files from redist.txt comes with SQL7.0 CD
2.Follow the instructions in that file to register necessary Dll’s
a.They are:
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
Example: regsvr32 \mssql7\binn\dtsffile.dll
The sqlwoa.dll and sqlwid.dll files should reside in the
system folder (i.e., \winnt\system32 or \windows\system).
3. Make sure to create DTS package from the Server itself, otherwise it doesn’t work right.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply