x
login about faq Site discussion (meta-askssc)

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 2 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.

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.