Passing connection String of Datasource in SSIS 2008

I am having Parent package which calls the three diffrent child packages,I used the datasource as OLEDB connection, in which all packages uses the same datasource.How to pass connection string of datasource from parent package to child packages using dtexec.exe utility.

more ▼

asked Jun 23, 2010 at 08:34 AM in Default

BasavaPrabhu gravatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest

Make configuration file and use

  dtexec /f "c:\pkgOne.dtsx" /conf "c:\pkgOneConfig.cfg"

It is an example where your SSIS package resides on FIle system and the next is the path of the configuration file, and if you want to pass the variables from Parent package to child Package then you can use "Parent package variable" property in Configuration file. Hope the link http://msdn.microsoft.com/en-us/library/ms162810.aspx will help you. Thanks.

more ▼

answered Jun 23, 2010 at 11:37 AM

Deepak Sharma gravatar image

Deepak Sharma
72 3 3 5

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 23, 2010 at 08:34 AM

Seen: 2768 times

Last Updated: Jun 23, 2010 at 08:40 AM