Passing connection string from parent to child packages

• rakesh_itcvrce

  Mr or Mrs. 500

  Points: 512

  More actions

  June 14, 2012 at 12:56 am

  #258066

  Hi,

  I have 1 parent package and 10 child package. I want to use parent connection string for all child packages. In all child packages I have used Oracle source connector and ADO destination.

  To achieve this I have created one variable in parent package called “ParentConnString” and gave value: SERVER=XXXX;USERNAME=XXX;PASSWORD=yyyyy;ORACLHOME=;ORACLEHOME64=;WINAUTH=0;

  In the child package – for package configuration, I have selected “Parent package variable” and provided parent variable “ParentConnString” than next -> next -> finish.

  When I am running parent package… child package is giving error “[Connection manager "Oracle Connector 1"] Error: OCI error encouneterd. ORA-01005: null password given; logon denied”.

  I have also tried creating a variable in the child package with same name as in parent package i.e “ParentConnString” and used the same value “SERVER=XXXX;USERNAME=XXX;PASSWORD=yyyyy;ORACLHOME=;ORACLEHOME64=;WINAUTH=0;” but this is also not working.

  Please suggest me the solution.

  Thanks in advance.

• thealek

  Valued Member

  Points: 59

  More actions

  June 15, 2012 at 4:25 am

  #1501512

  Have you defined an Expression for the DB connection: ConnectionString = @[User:ParentConnString] ?