September 13, 2006 at 1:46 pm
Here is the error. It is SQL Server 2005 64-bit installation into a cluster:
*** Create Package object failed
OLE Automation Error Information
HRESULT: 0x80040154
Source: ODSOLE Extended Procedure
Description: Class not registered
Any help would be appreciated.
September 13, 2006 at 1:59 pm
It seems to me like you are trying to create an dll that is not registered...
But I'm just guessing.
September 13, 2006 at 2:01 pm
Yes. And it appears to be odsole70 with the xp_OAxxx procedures. Found out how to register, but getting "DLLRegisterServer entry point was not found".
September 13, 2006 at 3:13 pm
Sorry, got no guess on that one... Maybe the registration failed or didn't complete somehow?!
September 13, 2006 at 3:57 pm
Yeah, we're not finding a whole lot of help out there. It may be an issue of a DTS Package created in 2000 32-bit trying to run on 2005 64-bit.
September 14, 2006 at 6:45 am
All I can offer is silent support.
Good luck sir.
September 14, 2006 at 11:44 am
Coded a work around to call "dtsrun" from the xp_cmd_shell to run the package.
That worked great. Thanks for the support, but this is the downside is being on the "bleeding-edge" of this product.
November 12, 2007 at 1:37 am
Hi
I can solve this problem in debug mode by right-clicking on the project in solution explorer , choose properties then go to debugging and switch the Run64bitruntime to False.
if you run from a job you'll need to run the 32 bit (x86) version of dtexec.
and use the full path to point to the exe and run it in a cmdexec type jobstep e.g. "D:\Program Files\Microsoft SQL Server (x86)\90\DTS\Binn\DTExec.exe" /file "Z:\testreport.dtsx"
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply