Execute package task connection string

Posted on 2011-02-28
Medium Priority
Last Modified: 2012-05-11
Hi experts,

   I have a SSIS project with 10 packages. All are stored in the file system.
From the master package, I want to place Execute Package task and set the properties(Location: File System) and connection to be dynamic.
I have created File connection manager.
How can I set the Execute Package Task properties to be dynamic. I have set the package configurations(configuration values are in the local DBAdmin database, SSISConfig table).

If I want to call 10 packages from the master package using Exec Pack Task, do I need to create 10 File Connections?????
Question by:rajvja
LVL 39

Accepted Solution

Pratima Pharande earned 1500 total points
ID: 34996607
yes you need to create 10 connections
LVL 11

Author Closing Comment

ID: 35004944

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question