How to Find list of database objects in SSIS package in Sql server 2008
Posted on 2013-02-06
I am new to SSIS package ,we have one of the jobs failed in sql server 2008 and this job is referring to SSIS package and this package is referring to 10 other packages .To find out what went wrong with the package ,
1) I need to find list of database objects (Stored proce,tables, views etc) in all 10 pakcages without manually going to each package.
2)How to debug a SSIS pakcakage ?
3) In the above case, Do I need to debug all the packages ? Does the system maintain error log for SSIS packages?
Thanks in Advance