US 2019/0171750 A1Published application

Sql server integration services (ssis) package analyzer

AssigneeBank of America Corporation

InventorNishanth Maraboina

Life of this patent

Estimating the term…

Loading patent…

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.

Claims20

Dependent claims

A system for execution of SQL Server Integration Service (SSIS) package, the system comprising:

at least one non-transitory memory device with computer-readable code stored thereon;
at least one processing device;
and
at least one module stored in said memory device and comprising instruction code that is executable by the at least one processing device and configured to cause said at least one processing device to:
electronically receive a user request to execute one or more SSIS packages, wherein each of the one or more SSIS packages comprises one or more steps;
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 of the one or more files at each of the one or more steps, wherein parsing further comprises identifying 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 based on at least one or more data flows and one or more control flows, wherein executing further comprises exporting data;
and
load the exported data into one or more external databases.

11 more elements

A computerized method for execution of SQL Server Integration Service (SSIS) package, the method comprising:

electronically receiving a user request to execute one or more SSIS packages, wherein each of the one or more SSIS packages comprises one or more steps;
retrieving the one or more SSIS packages;
initiating 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 of the one or more files at each of the one or more steps, wherein parsing further comprises identifying 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 based on at least one or more data flows and one or more control flows, wherein executing further comprises exporting data;
and
loading the exported data into one or more external databases.

7 more elements

A computer program product for execution of SQL Server Integration Service (SSIS) package, the computer program product comprising a non-transitory computer-readable medium comprising code causing a first apparatus to:

electronically receive a user request to execute one or more SSIS packages, wherein each of the one or more SSIS packages comprises one or more steps;
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 of the one or more files at each of the one or more steps, wherein parsing further comprises identifying 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 based on at least one or more data flows and one or more control flows, wherein executing further comprises exporting data;
and
load the exported data into one or more external databases.

7 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/830,966Filed 4 Dec 2017
Published: 6 Jun 2019
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/258
Integrating or interfacing systems involving database management systems: data format conversion from or to a database
G06F 16/245
Querying: query processing
G06F 16/254
Integrating or interfacing systems involving database management systems: extract, transform and load [ETL] procedures, e.g. ETL data flows in…
G06F 40/205
Natural language analysis: parsing

Family

US 11,055,310 B2Related patent
US 2019/0171750 A1This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key