Package configuration for SSIS packages allows us to store configuration for the packages in a variety of locations. One of those which can be particularly beneficial – database configuration. Here we’ll look at 3 benefits to leverage when using database configuration: If you wanted a quick refresh, I’ve previously looked at Package Configuration and how we set […]
Case sensitivity in data can trip us up unknowingly and Integration Services is no exception. Depending on the components we’re using we may notice different behaviour. Without understanding the way case sensitivity is treated within SSIS packages, we may see unexpected results with string comparisons. Let’s clear things up and dive into a few examples […]
When handing data we can make use of temporary tables to aid with separation or performance. However, they don’t always play nice with Integration Services packages. If we set a source to call a procedure returning the contents of a temporary table we’ll see an error like below: The process is unable to determine the […]
Andy Brownsword 