Home Forums SQL Server 2005 SQL Server 2005 Integration Services Delta Load in SSIS RE: Delta Load in SSIS

  • January 15, 2018 at 5:27 am

    #1975884

    dssingh17-819020 - Monday, January 15, 2018 3:27 AM

    vishal.kunwar - Wednesday, December 2, 2009 1:01 AM

    Hi,Here are the details:I need to add a parameter to the SSIS package that identifies FULL vs. DELTA, i.e., PROCESSTYPE = FULL or DELTA. For the original Vurv process, the SSIS package will be kicked off passing the FULL parameter value. For the new Taleo feed files, the SSIS package will be kicked off passing the DELTA parameter value.And i dont have date column in my source table, i have primary key.vishal

    I know this is very old post, but the reply may help someone.
    You can use a package variable and assign the value to it from config file. Package will first read this variable and on the basis of it's value, it will process.

    After nine years, one would hope that the OP solved their problem, one way or another!
    But I believe the original question was a general one, asking how to load changes and how to do a full load, based on the value of a package variable.
    I previously stopped posting to the thread because the OP did not provide the answers to the questions I asked ...

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.