x

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 '10 at 08:34 AM in Default

BasavaPrabhu gravatar image

BasavaPrabhu
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 '10 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x899
x22

asked: Jun 23 '10 at 08:34 AM

Seen: 2518 times

Last Updated: Jun 23 '10 at 08:40 AM