Solved

store db connection in config file or pkg variable?

Posted on 2016-08-17
1
42 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
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

SQL Server  2012 Release with lots of Enhancements in Database Engine functions, SSIS, SSRS and some of new services like Data Quality Server and Master Data Service. Of particular interest, and the focus of this Article is SSIS. So, time to elab…
I have a large data set and a SSIS package. How can I load this file in multi threading?

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