SQLTeam.com | Weblogs | Forums

.Config Help in SQL Server 2014


#1

Hi Gurus,

I need urgent help.
I have SSIS Package in SQL Server 2008 R2. This SSIS Package (.dtsx) I am calling from C#. Everything is working fine no issue so far. In 2008 R2, I am creating .Config file to pass username/password to connect the DB. Like I said everything is working fine without any issue. The package is just reading a flat file and do some transformation and insert that data into SQL Table.
My question is now I am going to migrate this SSIS Package to 2014. Correct me if I am wrong In 2014 we can't create the .config file. Then what should I do to pass SQL Credential? like I did in the .config file.
Please guide me. Let me know if my question is not clear or need more information.

Thank You.


#2

Hi,

How are you passing credentials while package is getting executed from the server? Are you using configuration/parameters for passing the values?

If you're using SQL Configuration you need to pass password as a config item.


#3

In .Config file, I am saving the value of "SQLServer Name"/UserName/Password.


#4

that will also work in 2014