SSIS

Transport data to and from flat files

SSIS
Client based in U.S.A

The challenge

Our customer often wants us to develop custom packages which either extract data from their databases to flat files or load data from flat files in their databases.

The solution

We have developed several custom packages which meet the requirements of the customer.  

The packages offer flexibility to configure certain parameters like server/database from which to extract data and, the location of output files.

Apart from the custom business requirement that varies from package to package, a common logging mechanism is implemented in each package.  

Logs keep track of the following

• Name of file from which the data was loaded (in case of import packages)  
• Execution time taken by the packages  
• Number of records affected(read/inserts/updates/duplicates)  
• Values of dynamic inputs (e.g., the location where the file was extracted for a particular execution of the package)  
• Errors, if any