SSIS, how to pass in connection string variable from master package to child package

See more:

C#

VB

SQL

Visual-Studio

SSIS

, +

I have a line of connection string stored in a table. When I run my package, it will call and execute another package. The process task will pull the connect string from the table then stored it as a variable then pass onto the child package.

Provider=SQLNCLI10;Server=153.191.61.44;Database=STAGE;Trusted_Connection=yet;

The argument I am using in my process task:

"/FILE \"" +  @[User::entityStagePackage] + "\" 
/SET \\Package.Variables[User::controlCount].Properties[Value];\"" + (DT_WSTR,10) @[User::controlCount]  + "\" /SET \\Package.Variables[User::fileID].Properties[Value];\"" + (DT_WSTR,10) @[User::fileID]  + "\" 
/SET \\Package.Variables[User::filePathName].Properties[Value];\"" + @[User::filePathName]  + "\"" + " 
/SET \\Package.Variables[User::archivePath].Properties[Value];\""    + @[User::entityArchivePath]  + "\"" 
+ " 
/SET \\Package.Variables[User::stageID].Properties[Value];\"" + (DT_WSTR,10)@[User::stageID] + "\"" 
+ " 
/SET \\Package.Variables[User::MasterExceptionPkg].Properties[Value];\"" + (DT_WSTR,100)@[User::MasterExceptionPkg]  + "\"" + (DT_WSTR,500) @[User::iniVariable]

When executing the package, I got error message because of variable @[User::iniVariable]:

/Conn OH_STAGE;Provider=SQLNCLI10;Server=153.191.61.44;Database=STAGE;Trusted_Connection=yes;" at "", The process exit code was "6" while the expected was "0".

If I take (DT_WSTR,500) @[User::iniVariable] out from my argument, the package run successfully. Can anyone please point out what's wrong with my connection string variable.

Evaluate Expression look like below:

/FILE "" /SET \Package.Variables[User::controlCount].Properties[Value];"0" /SET \Package.Variables[User::fileID].Properties[Value];"23" /SET \Package.Variables[User::filePathName].Properties[Value];"" /SET \Package.Variables[User::archivePath].Properties[Value];"" /SET \Package.Variables[User::stageID].Properties[Value];"26" /SET \Package.Variables[User::MasterExceptionPkg].Properties[Value];""
/Conn metaDBl; "Provider=SQLNCLI10; Server=153.191.61.44; Database=STAGE; Trusted_Connection=yes;"

Thank you!