SSIS, SQL Simantics

SSIS: Show Values of Variables in Progress or Execution Results

Randy Sims SQL Server

Here’s a simple way to show the values of variables in an SSIS package. This will allow you an easy way to view whatever variables or parameters you want to see in the progress or execution results of a package. It will also be visible in the Execution Report in the Integration Services Catalogs. This […]

Create an SSIS Package to Import a File

Randy Sims SQL Server

This is an easy run through tutorial of how to create a SQL Server Integration Services (SSIS) package to import a file. This is the most basic task there can be for a product named “SQL Server Integration Services.” We are going to connect the database to a file so the data from the file […]

SSIS: Change Encryption on a Project and Packages

Randy Sims SQL Server

When creating packages, the default security protection level is set as EncryptSensitiveWithUserKey. The user key mentioned is created off of the login of the user who created the project. If a developer other than the one who originally created the project or package opens it, they will receive the following warnings: