Solved

Execute package task connection string

Posted on 2011-02-28
2
423 Views
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?????
0
Comment
Question by:rajvja
2 Comments
 
LVL 39

Accepted Solution

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

Author Closing Comment

by:rajvja
ID: 35004944
thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

828 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