Categories
SSIS

Building SSIS Project Configuration

Last week we looked at configuring SSIS packages using package configuration. This week we’ll look at another approach for configuration: Project Configuration Project Configuration is the standard way to configure projects. This took over from the legacy approach which we looked at last week. This method allows us to share common parameters and connections across an […]

Categories
SSIS

Deploying SSIS Projects with Custom Components

Within SSIS you can make use of custom components which aren’t present out of the box. An example of some would be the Azure Feature Pack if you’re working with cloud resources. These will let us use features not available natively. They can also provide a challenge down the line when we come to deploy changes to […]