?
Solved

store db connection in config file or pkg variable?

Posted on 2016-08-17
1
Medium Priority
?
48 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 2000 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

In a previous article I've shown you how to import data from an Excel sheet using the OPENROWSET() function (http://www.experts-exchange.com/A_3025.html).  And I concluded by stating that it's not the best option when automating your data import. …
From time to time, for debugging and troubleshooting your flow at run time you’ll need to check if the variable has the correct value or not, there’re several ways to check for the value of the variables inside the flow, You can add Break Points, a …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month14 days, 7 hours left to enroll

770 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