July 12, 2010 at 9:28 am
Hello Everyone
Hope that you had a great weekend.
I am beginning to work on converting some old DTS packages to nice shiny new SSIS packages using SQL 2008. As something normal, these packages reside on a single SSIS Server, and will be called from each of the SQL Server on the Network. Some of them are Dev, Some QA and some Prod.
Now my question: How would you advise to allow or have all the SQL login information to be stored in one SQL table? I have used the SQL table in some of the examples from books. I would like to keep all the server, login information in a single location.
How can this best be accomplished? Please advise.
Thanks
Andrew SQLDBA
July 13, 2010 at 3:15 am
This was removed by the editor as SPAM
July 13, 2010 at 5:04 am
As a matter of fact you may employ a combination of XML configuration files which store the Connection string details(acting as a pointer to DB) and SQL tables for login credentials(Considering the fact that they provide solid encryption)
Hope this helps
Cheerz!!!:-):-):-)
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply