Post reply

Need help for SSIS Package?

  • August 2, 2013 at 1:08 am

    #280745

    Dear all ,

    i have design ssis package for oracle source to sql destination.scenario is new records are comes to be insert and exiting records are comes we need to update table.

    i have design the package,but records are not updated,evertime records are appending.

    please help me on this!

    i have attached package.

    further clarification please refer this post:

    http://www.sqlservercentral.com/Forums/Topic1475870-364-1.aspx#bm1476004

  • August 2, 2013 at 1:34 am

    #1638075

    Hi,

    Kindly check your lookup mapping and if its fine then check in the data level.

    Sometimes it creates problem due to Trimming issue. So, you can check by Trimming(LEFT and RIGHT both) the input data and Lookup data and varify with Data Viewer.

    Thanks,

  • August 2, 2013 at 1:46 am

    #1638080

    Have a look at the 'Stairways' series for SSIS - this one[/url] may be relevant to your situation.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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