what is environment variable configuration in ssis and what registry entry configuration in ssis

sql ssis etl ssis-2012 msbi
Ghayaz Dot Net Apps Developer picture Ghayaz Dot Net Apps Developer · Oct 6, 2016 · Viewed 12.1k times · Source

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I am not understanding what is Environment Variable configuration and what is registry entry configuration in SSIS.

enter image description here

Answer

Shiva picture Shiva · Oct 6, 2016

The Environment Variable configuration means that you want to configure your variable(s) in the SSIS Package to take the value from an Environment Variable. Environment Variables are set at the Computer / Server / System level.

For example, you could store the connection string for a database in an environment variable and configure all your package that run on that server, and use that database, to take the connection string value from that variable.

enter image description here

Same with Registry Configuration setting, where you have Registry keys that contain your SSIS variable values.

See the following MSDN Article for detailed explanation on all the configuration types.

Defining a Configuration Approach for Integration Services Packages

I know SSIS tends to be a little confusing when you get started :) I went through the same issues.

Related questions

SSIS error: delimiter for column "columnX" is not found

This question was asked here before but the solutions proposed don't seem to be working for me. I'm trying to import a text file pipe delimited text qualifier ". The SSIS package is returning the error message delimiter for column "columnX" …

Read More
convert Excel Date Serial Number to Regular Date

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted cells in excel these are converted as 36464 => 1/11/1999 37104 => 1/08/2001 35412 => 13/12/1996 I need to do this transformation in SSIS or in …

Read More
SSIS - fill unmapped columns in table in OLE DB Destination

As you can see in the image below, I have a table in SQL Server that I am filling via a flat file source. There are two columns in the destination table that I want to update based on the …

Read More