Real Time SSIS Secnario.

SSIS
Requirement: We have to Load .txt file to SQl Table.

Step1: Check File is exist or not in folder, If not Send a mail to User “File does not Exists”.

Step2 : Load the File on the basis of First come First Load, Below is the sample file name               containing  date and time stamp.

filename

Step3: Before Loading data into Destination Table Check if there is any Duplicates records in File and also check Resource Hours Should be not greater than 8.

Below is sample File records .

filesample

Step4: After Cleansing is complete Load the File into  Destination Table.

Step5: After Successfully Loading Data into Destination , create Monthly Archive Folder.
Step6: Then Send Mail to user  “File Loaded Successfully , With Your Server name”.

Enjoy Weekend with SSIS 🙂

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s