Post reply

Can i store a value in a variable

  • May 23, 2010 at 10:13 pm

    #224935

    Hi,

    I have automated the process of transferring rows from one table in access database to a table in sql server database.

    Now instead of transferring all the rows each day i want to store the value of the ID column of the last fetched row in some variable and next day i want to start fetching rows from that ID value onwards.

    Currently I m fetching all the rows and then i will delete rows which are of previous date based on datetime value.

    Since its almost 3 lac rows it takes too much time.

    So i want to go with the above logic. Please please help me how to do it?

    Thank you

  • May 24, 2010 at 12:51 am

    #1171394

    You can't persist the value IN the package from run to run. HOWEVER you could query the max id from the destination at the start of the package run and then use it during the select of the data source and then you would not have to delete anything..

    CEWII

  • May 24, 2010 at 1:34 am

    #1171400

    Thank u Elliott. It is Really good logic.

    Thank u very much for reply. 🙂

    Sachin

  • May 24, 2010 at 7:50 am

    #1171565

    You are welcome. I have used this logic many times and it has worked great for me.

    CEWII

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

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