April 27, 2012 at 3:28 am
We are using sqlserver 2008 and one of our job fails with the below errror.
DTSRun: Loading... Error: -2147220213 (8004050B); Provider Error: 0 (0) Error string: The package cannot be loaded from a 64-bit SQL Server. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 705. Process Exit Code 1. The step failed.
Can any one give me an idea about the issue as i dont know much about DTS.
Please help me...
Many Thanks.
April 27, 2012 at 3:35 am
The package cannot be loaded from a 64-bit SQL Server.
This is a mismatch between the SQL Server and the Integration Services Module.
I think that your SQL Server is 64bit but the Integration Services module was installed as 32 bit or the package was created using a 32bit version of SSIS.
Did you create the package on the same system as on which you are trying to execute the package?
April 27, 2012 at 9:20 am
DTS package was not created on the same system
issue seems to be 32 bit /64bit machine issue.
can you please tell me how to convert the pacakage to 64 bit...
Please guide me.
April 27, 2012 at 9:42 am
Does this help: http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html
You could try upgrading them to SSIS: http://www.mssqltips.com/sqlservertip/1224/upgrade-sql-server-dts-packages-to-integration-services-packages/
April 27, 2012 at 11:20 pm
DTS does not work in 64 bit runtime
Try this:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply