SSIS doesn´t execute all task
I have one "Main Package" that executes other Packages thrue the Execute Package Task. The problem is that all tasks in child package doesn´t execute.
For example:
Main Package executes package "Product", the Product package exists of 4 different Data Flow Tasks, 2 of them inserts data to the right table. The other 2 doesn´t insert any data. Although there are data in det source table.
When i debug i BIDS it works, but in SQL Server Agent it doesn´t. I tried to create one Agent job for one childpackage and it worked. But when I tried to execute more than one package through SQL server agent it doesn´t return any data.
What to do?? Feels like I have tried all...
May 23rd, 2011 6:48am
do you got any error during execution from sql server agent? if yes, put exact error message herehttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2011 6:51am
No I don´t. It complets successfull.
I´m not sure if SQL Server Agent is using the config file. I am using the config file to modify DataSources, Time parameters and ChildPackagePath. Alla packages is reusing the same config file. The package path is different in the production environment
so I think that value is passed but I´m not sure. Is there some way to se the values of the config file that is passed to SQL server agent?
May 23rd, 2011 7:12am