Best way to save state between SSIS package runs?

  • I have a variable which acts as a counter, and I want to increment it on each run of an SSIS package and use it inside the package also.

    I use XML configuration files to store other variables, but I haven't seen anything about storing changes to those variables back. I suspect you can't do this... am I wrong?

    If it's not possible, I'll probably just store the number in a fixed text file. (A database table would be cleaner but it's something that should just be used for a few months and I'd have trouble getting it approved "in production").

  • Either store it in a table or in a flat file. You could update your configuration file yourself, but oh boy if something goes wrong there 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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