Vivek S


Hi,

We have used an execute package task in our master package to execute a child package and we have set the execute out of process=false. This master package is running fine in 32 bit server but is failing in 64 bit server. is there any settings to be done in the server or is it the problem with the property setting(execute out of process)

Vivek S





Re: Issues with execute package task in SSIS

Phil Brammer


Please provide the specific error(s) you are receiving.






Re: Issues with execute package task in SSIS

Vivek S

Hi Phil,

Here is the error msg i am getting.

Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run.

Thanks & regards

Vivek S






Re: Issues with execute package task in SSIS

Crispin

Can you run the child package on it's own on the x64 machine







Re: Issues with execute package task in SSIS

Rafael Salas

A package may fail validation for many reasons. Make sure the 64 bit server have the 64 bit version of the drivers used by the connection managers. Also notice that you could force the execution of the package in 32 bit mode (via dtexec).

BTW how are you running the package Have you tried runnig them via dtexec to see if you can get a more detailed error






Re: Issues with execute package task in SSIS

Vivek S

Hi,

The package exection fails irrespective of whether we run using dtexec from command prompt or from integration services.

we tried both ways, still it fails.

Just a check. its the RTM version of SQL which in currently in the 64 bit m/c where the pkg is failing where as the 32 bit m/c are applied with SP1. can this patch make a difference.

Vivek S





Re: Issues with execute package task in SSIS

Vivek S

Hi Crispin,

Yes the child package executes successfully when executed saperately.

Vivek S





Re: Issues with execute package task in SSIS

Phil Brammer

Vivek S wrote:

Just a check. its the RTM version of SQL which in currently in the 64 bit m/c where the pkg is failing where as the 32 bit m/c are applied with SP1. can this patch make a difference.

Vivek S

Sure, it can make a difference.






Re: Issues with execute package task in SSIS

jwelch

How are you executing the child to test it, and how are you executing the master




Re: Issues with execute package task in SSIS

Phil Brammer

First, any Excel connections There isn't an Excel connection manager in 64 bit mode.

Second, try running the package in 32 bit mode (use the 32 bit executable) on the 64 bit server.





Re: Issues with execute package task in SSIS

Vivek S

Hi,

The issue is solved post SP1 application in 64 bit m/c. Thanks to all for the suggessions given for my posting.

Regards,

Vivek S