Here's a post I wrote a while back about this very scenario: https://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/

The last two screenshots show two different storage locations for SSIS packages. The second screenshot, under the heading "Integration Services Packages", shows those packages that are deployed to the SSIS...

Phil, by chance does the package use checkpoints? I've seen some odd behavior like this when checkpoints were enabled and the required checkpoint file was moved or deleted.

Hi Pete,

If that event handler uses a variable - even if it just reads it - it might be causing contention that leads to this error. If possible, test the...

Pete, does your package use any event handlers? I've seen this error pop up on occasion when event handlers are accessing variables.

I'd check in the project directory in Windows Explorer to see if the missing package files (*.dtsx) are there. In all likelihood, the files are there, but aren't listed as...

Hey Ken, best wishes for a quick recovery! Looking forward to your next SQL crossword puzzle 🙂

If I can do anything for you and for family, I'm just up the...

Just to be clear, is it the execution history or the version history that is missing?

If you're using the SSIS catalog for storage and execution, it will automatically purge old...

Brian,

Regarding how to break up logic into individual packages, I'm a fan of smaller SSIS packages that each do just one unit of work. This design makes development, testing, and...

Phil, that's the same way I handle it. It feels a little clunky, but it works. Function before form 🙂

Thom, it does let you move them around, but it doesn't persist that change. If you modify the task on either end of the constraint in any way (move, rename,...

Unfortunately, you have little control over how those precedence constraints are displayed. You can move around the tasks and containers, but can't directly manipulate how precedence constraints are laid out.

As...

In SSIS expression language, there is no IF() function. You'll need to use the conditional operator, which looks like this:

(someCondition) ? valueIfTrue : valueIfFalse

This correlates to the...

That's correct, except that you don't need two asterisks the file spec. A single asterisk will match multiple characters, so you could simply use SVPP_ROYA_00001_00021_20200225_*.csv.

You can use an expression to set this property. As shown below, you can use a hard-coded expression to define this. If you already have a variable with this file...