variable in ssis config

  • 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

  • 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>

  • ok I will go with that

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply