Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS .config file Help...
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tooba
Posting Yak Master

224 Posts

Posted - 02/16/2015 :  10:34:48  Show Profile  Reply with Quote
I am having SSIS .config file questions. I have very simple package
One 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 - 02/16/2015 :  12:17:25  Show Profile  Reply with Quote
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....
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000