Post reply

Delta Pull for new added data

  • July 9, 2012 at 10:52 am

    #259172

    Hello guys,

    I have created SSIS Package to pull some data ,we update data every week .But now i need to pull last week data(Data that updated after i run my package) .

    Need to pull data that i don't have in my flat file .

    From last week i need newly added data not the one i already have . How can i do that ?

    Let me know if any other information needed .

    Ankit

  • July 9, 2012 at 12:10 pm

    #1510487

    You need a query that tells you what is the new information from last week. I'd start by writing that query in T-SQL to get the changed data based on something in the table, or some tracking mechanism(CT/CDC).

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply