I have SQL JOBS that run my SSIS Packages each night.
I have a FIX to one of my packages that needs to be deployed tonight and the normal SQL JOB that runs the normal package, runs at 7pm each night.
Question: Can the SSIS Package that contains a small FIX, be deployed AT THE SAME TIME as the normal SSIS Package is "running"?
We may NOT be able to "disable" the SQL JOB in time to prevent the 7pm running and so this is why I'm wondering.
SQL SERVER 2008 is our system.