Hello guys,

I have a problem with calling other Packages from my SSIS 2012 Package "Main.dtsx". I have an "Execute Package Task" in Main which calls "MyPackage.dtsx".

If the ExecuteOutOfProcess Flag is set to "False" everything works fine. When I switch to "True" I get the following error:

Error: 0xC0202009 at Any Component, MyPackage Destination [337]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004002.
Error: 0xC0202040 at Any Component, MyPackage Destination [337]: Failed to open a fastload rowset for "[SCHEMA].[TABLE]". Check that the object exists in the database.
Error: 0xC004706B at Any Component, SSIS.Pipeline: "MyPackage Destination" failed validation and returned validation status "VS_ISBROKEN".
Error: 0xC004700C at Any Component, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Any Component: There were errors during task validation.
Error: 0xC0022102 at Execute MyPackage: Error 0xC0012050 while executing package from project reference package "MyPackage.dtsx". Package failed validation from the ExecutePackage task. The package cannot run.

The strange thing is that I could not see any difference in SQL Server Profiler in both cases. All statements against my SQL Server 2012 Database are executed as my own user which is "sa". Do you have any idea what's causing this problem? Best wishes,

Hi Manuel,

Did you set DelayValidation to True for the Data Flow Task and the connection managers in the Data Flow Task?

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.

Hello Katherine,

Good point - I did not set them. Now I've tried to set all parent Containers and all Connection Managers to DelayValidation = TRUE. Still the same issue. The sub-package runs some Execute SQL Tasks without any Problems and when it Comes to the first Data Flow Task the Validation starts and produces the error.

Thanks,

Manuel

Hi Manuel,

If the ExecuteOutOfProcess Property of Execute Package Task sets to true, then the child package will run in a separate process from the Execute Package Task. If it sets to false, the package invoked by the Execute Package Task runs in the same process. The default value is false.

So when switch the value to true, we can get the error message. To fix this issue, please set DelayValidation=FALSE at the package level and to set DelayValidation=TRUE for all the tasks in the child package.

The following similar thread is for your reference:
https://social.msdn.microsoft.com/Forums/en-US/43c84491-66f8-4a61-bd97-54a824d56be7/error-using-execute-package-task

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.

Hi Katherine

Thank you for your answer. Unfortunately, this does not work. I missed to post that I've already tried to set DelayValidation to True. The Error during the execution when SSIS starts the delayed Validation Phase. So the sub-package starts fine and crashes when it comes to the execution of a Data Flow Task containing my Destination.

Best wishes,

Manuel



Hi Manuel,

Did you set DelayValidation to False for the child package in the package level?

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.

Hi Katherine

Yes, and I guess that I have now tried every Variation of all DelayValidation flags that are possible. Seems not to be the Problem in my opinion. When turning fastload Options off, it works as well (but it's not a valuable Option).

Maybe it's not important, but the table will not be created by SSIS - it exists physically when starting the Process.

Thanks,

Manuel