.Config Help in SQL Server 2014

SSIS and Import/Export
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