Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2015-02-16 : 10:34:48
|
| I am having SSIS .config file questions. I have very simple packageOne DF ==> Inside the DF I am using Flat File Connection manager and SQL Destination. SQL Connection Manager, I am using SQL Server Authentication instead of Window Authentication, I used Username and Password and test connection everything looks good. Now I want to Schedule this job through SQL Server Agent.I create .config file to save SQL Connection Manager (Username and Password). If I run SSIS Package through SQL server agent JOB is spening/spening and spening and nothing happend, however If I update my SSIS Package with Protection Level = EncryptSensitiveWithUserKey and provide password and save the package. Now go back to SQL Server agent and update my package and provide I same password that I used in SSIS Package (Package runs fine).My questions is what is like this, my understanding was if I create a config file and save username and password in .config file we don't need to do any other extra step. Please guide me, am i doing something worng here?or it should be like this. Thank You in advance! |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2015-02-16 : 12:17:25
|
| Ok I got it. I have to change Protection Level to DONTSAVESENSITIVE to use my .Config file. It is working fine without any issue.Thanks.... |
 |
|
|
|
|
|
SSIS .config file Help...