Solved

store db connection in config file or pkg variable?

Posted on 2016-08-17
1
45 Views
Last Modified: 2016-08-22
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
Comment
Question by:elucero
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 16

Accepted Solution

by:
DcpKing earned 500 total points
ID: 41761683
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question