• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • 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.
1 Solution
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

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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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