ReportDr00
IS-IT--Management
Hello
I have a package that extracts data from 10 database that are have same structure and i am dynamically changing the connection in a foreach loop, but the package fails as soon as it encounters any errors and i would like to continue with next and log the errors in a flat file.
I have sql task that returns info of each database like connection string, query and date and stores it in recordset object and foreach loop reads the recordset object and executes the query and extracts data and stores it in datawarehouse. I want the package to log errors and continue execution automatically. how can i do this, any ideas would be appreciated greatly.
Regards
Armani
I have a package that extracts data from 10 database that are have same structure and i am dynamically changing the connection in a foreach loop, but the package fails as soon as it encounters any errors and i would like to continue with next and log the errors in a flat file.
I have sql task that returns info of each database like connection string, query and date and stores it in recordset object and foreach loop reads the recordset object and executes the query and extracts data and stores it in datawarehouse. I want the package to log errors and continue execution automatically. how can i do this, any ideas would be appreciated greatly.
Regards
Armani