Click here to Skip to main content
16,017,857 members
Please Sign up or sign in to vote.
4.00/5 (2 votes)
Hi friends,

We have planed to merge Database, for that we prepared packages using Data Flow Task for transferring records from our Base DB to Merge DB.

We prepared packages in different machines. Now we tried to consolidate all the packages(there are 9 packages each pack contains more than 100 tables)in a server machine and execute each package using Execute Package Task we get the following error message.

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


We saved the packages by selecting File-->Save Copy of PACKAGE.dtsx As..
and saving it in db server.


Can anyone help me?
Posted
Updated 25-Oct-22 6:34am
v2

1 solution

If you will load a ssis package from a SQL Server, under a proxy account, be sure to grant to that user db_ssisoperator on msdb database.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900