Bank of America Corporation
SQL server integration services (SSIS) package analyzer

Abstract:

Systems, computer program products, and methods are described herein for execution of SQL Server Integration Service (SSIS) package. The present invention is configured to electronically receive a user request to execute one or more SSIS packages; retrieve the one or more SSIS packages; initiate an execution of the one or more SSIS packages, wherein the execution further comprises: traversing through each of the one or more steps associated with each of the one or more SSIS packages; identifying one or more files associated with the one or more SISS packages at each of the one or more steps; parsing each file at each step to identify one or more SQL commands embedded in each of the one or more files; and executing each of the one or more identified SQL commands, wherein executing further comprises exporting data; and load the exported data into one or more external databases.