variable in ssis config

• super48

  SSCrazy

  Points: 2682

  More actions

  April 1, 2015 at 3:32 am

  #306185

  how to ad a package variable in a configuration file?.

  one method is right create config file choose objects variable.

  but in interview i attended in some x company the question asked

  what is method we can add variable in to config file without using check option in.

  regards

  Sudarshan

• kbatta

  SSCrazy

  Points: 2274

  More actions

  April 7, 2015 at 9:21 am

  #1789226

  Since the config file already exists, you can copy the code for one variable and change its name and value. You will need to figure out where one variable ends in the config file and the next one begins. I like to separate them with blank rows.

  Ex:

  <?xml version="1.0"?>

  <DTSConfiguration>

  <DTSConfigurationHeading>

  <DTSConfigurationFileInfo GeneratedBy="IHSIQ\kbatta" GeneratedFromPackageName="IS_AppUpload_MB_Member" GeneratedFromPackageID="{225460AA-DB51-43E4-8761-2695EB776221}" GeneratedDate="1/12/2009 12:44:26 PM" />

  </DTSConfigurationHeading>

  <Configuration ConfiguredType="Property" Path="\Package.Variables[User::CommonBufferTempStoragePath].Properties[Value]" ValueType="String">

  <ConfiguredValue>\\Sacsfps02\IT_Services\ETL\Dev\SSIS\SSIS_BufferArea\</ConfiguredValue>

  </Configuration>

  <Configuration ConfiguredType="Property" Path="\Package.Variables[User::Environment].Properties[Value]" ValueType="String">

  <ConfiguredValue>dev</ConfiguredValue>

  </Configuration>

  </DTSConfiguration>

• super48

  SSCrazy

  Points: 2682

  More actions

  April 8, 2015 at 7:21 am

  #1789525

  ok I will go with that