There are a handful of reasons for an “Ended Unexpectedly” package execution status in the SSIS Catalog. One reason is: the SSIS package was reporting a “Running” status when the SQL Server instance started. I can hear some of you thinking,… “How Did I Get Here?” The day earlier, I was testing some new SSIS …
Continue reading SSIS Catalog Execution Ended Unexpectedly
Category:SSIS Catalog
An SSIS Catalog Environment Task
In this post Andy shares thoughts about a new custom SSIS task I’ve written to set SSIS package variable values from SSIS Catalog Environment Variable values.
Manage SSIS Catalog Size
A few days ago, I (along with some smart people) were asked on Twitter how to manage the size of the SSIS Catalog. Since I’d heard this question a couple times recently, I decided it would probably make a good topic for a blog post. Welcome to the blog post! The gentleman who asked the …
Continue reading Manage SSIS Catalog Size