April 1, 2015 at 3:32 am
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
April 7, 2015 at 9:21 am
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>
April 8, 2015 at 7:21 am
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