Post reply

Increment Load in SSIS

  • October 12, 2010 at 8:22 pm

    #227832

    I have one column that i want to do incremental load every time For example.

    Field Name => APN_ID => Value = CMD-00001

    Next value should be => Value = CMD-00002

    I am transferring data from flat file "Source" and Target " SQL Table" and in one sql table i want to use incremental load that i show above. Please guide me how i can done in SSIS. Thanks.

  • October 12, 2010 at 9:45 pm

    #1235969

    Approach 1: Entirely handle the value increment using a Script Task

    OR

    Approach 2: Design package using FEL->ST->DFT/EST

    Raunak J

  • October 12, 2010 at 10:15 pm

    #1235973

    Thanks for your reply,

    Approach 2: Design package using FEL->ST->DFT/EST

    *I am sorry i don't understand what FEL,ST, DFT, AND EST stand for*

    Could you plz provide me code for "incremental load" Thanks.

  • October 12, 2010 at 10:35 pm

    #1235976

    Please google the same as many a times you would find the posters using the acronyms instead of the entire name. Hint (FEL=For Each Loop).

    Also, this is not an incremental loading as you say. It has all together diferent meaning in data warehousing...please google the same.

    I will not provide you the code for the task as it is relatively very simple and I would suggest you to do some research work for some time and solve the problem at your own pace.:-)

    Raunak J

  • October 12, 2010 at 10:59 pm

    #1235980

    Thanks for your lesson !

Viewing 5 posts - 1 through 4 (of 4 total)

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