March 21, 2014 at 3:09 am
Hi all i have been following this forum since very long time and it is really helpful to learn and improve. This is my first question here
I have an ETL which connects to a production server to extract data, i am using a service account in the connection string(hard coding it) package works fine. but when orther users tries to open it the package fails. The other main issue is, the connection string is used in many tasks of the package and when different user tries to open the package service account credentials are not being validated and when these validations fail for 3 times, the production server is locking the service account, which is a big problem.
how can i overcome this, instead of using hard coded credentials i can use a configuration table to the get these details, in addintion to this do i need to consider anything else to not face the above issue? your help will be appreciated
March 21, 2014 at 3:23 am
Duplicate post. Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1553367-148-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply