Link Details

Link 968943 thumbnail
User 1049989 avatar

By indiana_joy
via sqlknowledgebank.blogspot.in
Submitted: May 14 2013 / 13:05

Introduction: In this article I am trying to demonstrate the SSIS CHECKSUM Transform to determine the dynamic changes in sources. Case Study: Please understand the case study very well before drilldown to package level. There is a text file named "DuynamicData.txt". We are just going to extract this flat file and load it in our SQL Server table objects called "tbl_DynamicData". The source file structure is mentioned bellow PRD1;TOOTH BRUSH;100;25 PPD2;SAVING LOTION;214;250 PRD3;SAVING CREAM;240;130 PRD1 : is the product number and we are taking is as primary key. TOOTH BRUSH: is the product name 100 : is the stock quantity 25 : Price of the product So we have to load it into our MS SQL Table named "tbl_DynamicData". But the text file changed frequently, for example PRD1;TOOTH BRUSH;100;25 PPD2;SAVING LOTION;200;250 PRD3;SAVING CREAM;290;130 Here the Product quantity changed from 214 to 200, 240 to 290 and when we run the package it automatically determine the changes and changed it to our destination table accordingly. It juts copy the entire data at first time and each and every time it just look at the changes of source and act accordingly to change the destination table.
  • 1
  • 0
  • 123
  • 48

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (1)



Voters Against This Link (0)



    Apache Hadoop
    Written by: Piotr Krewski
    Featured Refcardz: Top Refcardz:
    1. Play
    2. Akka
    3. Design Patterns
    4. OO JS
    5. Cont. Delivery
    1. Play
    2. Java Performance
    3. Akka
    4. REST
    5. Java