x

Deploying 32bit SSIS packages to a 64 bit OS using a cluster

I have developed several SSIS packages. Delivered to first customer who was on 32 bit. No problem calling all packages through Agent jobs using SSIS package store. Delivered to 2nd customer who was running on 64 bit OS. Some packages got error message. Could not load package 'r:...' because of error 0xC0010014. I corrected error by changing the type of the package to CmdExec and running the command line like so: "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTexec.exe" -f "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MPSC Batch Jobs\OPIntInterStateDualParticipation.dtsx" -conf "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\MPSC Batch Jobs\OPIntInterStateDualParticipation.dtsConfig". I delivered to the 3rd customer who was also running on a 64 bit os. These guys are on a cluster too. Neither previous customer is on a cluster. I am still getting the "Could not load package" error. this occurs when CPackage::LoadFromXML fails. I am out of things to try. Anybody got a suggestion?

more ▼

asked Jun 17, 2010 at 09:51 AM in Default

avatar image

Sherry
13 2 2 4

Need some more details on the errors of this. On the cluster is Integration Services installed? On SQL 2005 the only way to run packages with 32 bit components (drivers mostly) is by using the CMDExec like you are doing. In SQL 2008 there is a native /x86 option in the task. Are you connecting to oracle or some other provider? Some versions of Oracle have an issue if there is an (x86) in the folder name of the instal path.

Jun 18, 2010 at 08:42 PM Jason Cumberland
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x54

asked: Jun 17, 2010 at 09:51 AM

Seen: 2540 times

Last Updated: Jun 17, 2010 at 09:51 AM

Copyright 2017 Redgate Software. Privacy Policy