What could be wrong?
I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4.
EXEC @rc = master..sp_OAMethod @Obj, 'Execute'
The linked server is SQL Server 2005 x64.ÃÂ Already installed is SQLServer2005_BC_x64.msi version April 15, 2006.ÃÂ Local server is SQL Server 2000 SP4.ÃÂ
I can execute the sproc successfullyÃÂ in Query Analyzer from my local dev box which has both 2000 and 2005 installed.ÃÂ Profiler in 2005 indicates success for the whole sproc.ÃÂ
ItÃÂ fails when I execute in Query Analyzer while connected on SQL 2000 SP4.ÃÂ Tried this withÃÂ 3 different machines SQL Server 2000 SP4.ÃÂ The server doÃÂ not have anyÃÂ 2005 component installed.
According to Profiler in 2005, the last event that happen is
if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec master.dbo.sp_MSSQLDMO80_version else if
(object_id('master.dbo.sp_MSSQLDMO70_version') is not null) exec master.dbo.sp_MSSQLDMO70_version else select 0
Below is the trapped Query Analyzer message.
Error Source: Microsoft Data Transformation Services (DTS) PackageÃÂ
Error Description:Package failed because Step 'dts_name_removed' failed.ÃÂ
Error code: 80040428 \
Error Help File:sqldts80.hlpÃÂ
Error Help Context ID:700ÃÂ
Step Error Source: Microsoft SQL-DMO (O
View Complete Post