Solved

SSIS SQL 2005

Posted on 2011-03-23
2
171 Views
Last Modified: 2012-05-11
I have a master package that calls a child package.  The child package is configured with EncryptSensitiveWithPassword.  How do I send the password to the child package from the parent package.  I'm using a Execute Package Task to call the child package and I entered the password there, however, when I run the parent package the prompt still comes up for the child password.

thanks.
0
Comment
Question by:yanci1179
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 35202004
One option would be to use DTEXEC utility switches and pass the appropriate values
http://msdn.microsoft.com/en-us/library/ms162810.aspx
Or use a configuration file for the second package where you can store these credentials.
0
 

Author Closing Comment

by:yanci1179
ID: 35392990
this was partial solution
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL server performance baseline 19 45
point in time restore in SQL server 26 41
sql server cross db update 2 20
SQL- GROUP BY 4 21
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

680 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