Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change deployed package connection password?

Status
Not open for further replies.
TheBrenda

TheBrenda

Programmer
Jul 2, 2013
1
FYI - There is a long story and I am just picking out a small peice of it.

We have deployed packages at multiple client sites. One of the connections in the packages are to an ISeries host and the connectionstring has a userid and password. The packages were deployed with protectionlevel 5 - ServerStorage. there is no configuration file. The are deployed in MSDB.

Is there a way to change the password on the packages without redeploying? Will dtutil or dtexec (or some other utility) allow passsword changes of an already deployed package in MSDB?

Thanks
 
Status
Not open for further replies.

Similar threads

TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
358
mark williams
mark williams
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
1K
mark williams
mark williams
Sathia sankar
  • Locked
  • Question
SSIS Package which was sheduled thr
Replies
0
Views
282
Sathia sankar
Sathia sankar
Hardik Thakkar
  • Locked
  • Question
Memory Error - while iterating Execute Package Tasks Multiple times
Replies
0
Views
140
Hardik Thakkar
Hardik Thakkar
sidharth221
  • Locked
  • Question
SSIS package failing from autosys
Replies
0
Views
216
sidharth221
sidharth221

Part and Inventory Search

Sponsor

Back
Top