Post reply

How to Load data to sql table from SSIS using Stored Procedure

  • June 27, 2007 at 5:26 am

    #179243

    Hi All,

    Can any one solve my proble.

    I did extract data from Excel Sheet and Load into Sql Table, my Package will run every day at 12 AM.

    But I am facing some problems,

          1.My excel sheet modified every day by end user, they will enter new data also

          2.I want hoe to i handle the data. my package loading same data to table.

          3.How to handle this issue. My package should check if data exists already it should update else insert, so hear i need to call Stored procedure.

     

    Please tell me how to call stored procedure or any other possible ways to solve it.

     

    Thanks

    P Senthilkumar

  • June 27, 2007 at 6:03 am

    #715489

    Use the lookup component to check each row in your data flow to the rows already inserted into your table.

    Any rows not found by the lookup component need to be redirected to the OLE DB Destinaiton (New rows) and any matching, use the OLE DB Command to do an update.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 28, 2007 at 4:21 pm

    #716015

    please stop cross posting, you are wasting our precious clicks

    Everything you can imagine is real.

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

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