Categories
SSIS

Elevating SSIS Package Configuration with Environment Variables

Package configuration allows us to retrieve variable values from a variety of sources. We recently looked at storing the values in a SQL database. We can elevate the database configuration a step further by using system level Environment Variables. In this post we’ll walk through that process. Using environment variables Where we previously looked at storing […]

Categories
SSIS

Harnessing SQL Server Package Configuration for SSIS Packages

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 […]