asked on

SSIS Environment Variable

Hi Experts,

I am new in SSIS. I have simple assignment to create SSIS package configuration. I have to create environment variable. But, they wanted through scripts task first which will check through variables and source and destination connection manager from scripts.

Please help me where to start?

Below is sample of environment variables configuration of old packages.

<?xml version="1.0"?>
<DTSConfiguration>
      <DTSConfigurationHeading>
            <DTSConfigurationFileInfo GeneratedBy="SKM\hari123" GeneratedFromPackageName="DBA New Server Setup" GeneratedFromPackageID="{0E5D12D7-8EDB-4C2C-89FA-CCFDAD34D44A}" GeneratedDate="2/3/2013 3:44:54 PM"/>
      </DTSConfigurationHeading>
      <Configuration ConfiguredType="Property" Path="\Package.Variables[User::Environment].Properties[Value]" ValueType="String">
            <ConfiguredValue>DEV</ConfiguredValue>
      </Configuration>
      <Configuration ConfiguredType="Property" Path="\Package.Variables[User::Servername].Properties[Value]" ValueType="String">
            <ConfiguredValue>ArrayDatabase</ConfiguredValue>
      </Configuration>
</DTSConfiguration>

ASKER CERTIFIED SOLUTION

ValentinoV

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

ValentinoV

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

sksamguru

ASKER

I've requested that this question be deleted for the following reason:

coz I didn't get correct answer

sksamguru

ASKER

yes

ValentinoV

I don't think a delete is the appropriate action here but more the result of a limitation by EE (three questions open). I've given some detailed info as best a possible and there was no further interaction from sksamguru. Therefore I object.

ValentinoV

Thanks modus_operandi,

without further interaction from asker, I'd go for option 4 with both of my comments as answer. Both contain some valuable info related to SSIS package config, which seems to be what the question is referring to.

#a39031123
#a39031128

Best regards,
V.