• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

store db connection in config file or pkg variable?

What would be best practice where to store a connection string. In a config file or a pkg variable? Or any other place?  Thanks for suggestions.
0
elucero
Asked:
elucero
1 Solution
 
DcpKingCommented:
With a server instance where a lot of the databases are involved in a lot of SSIS jobs, I've found that having a dedicated small database for information like this is convenient. I kept the information in tables, and wrote a few stored procedures that would return package data (such as connections, email information, file system locations, etc.) on being provided the package name. It was very convenient and had the advantages of being - by definition - available, being secured (by database security), and being protected (by backups, etc) from loss.

Hope this helps

Mike
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now