Home Forums SQL Server 2005 SQL Server 2005 Integration Services How to ensure value assignment to variables with package scope stick even in error situation? RE: How to ensure value assignment to variables with package scope stick even in error situation?

  • January 27, 2016 at 10:42 am

    #1854779

    utekjunk (1/27/2016)

    Thanks Phil for the suggestion. I will go back and review my approach.

    I am new to SSIS and don't know what the best practice is...

    that's something I have been wrestling in the last couple days whether to put something in SP or putting a big chunk of SQL in one task so that it is easier to manage or breaking them down into bit and piece...etc

    No good SQL developer will ever complain about you doing these things in a proc, in my experience 🙂

    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.