SSIS ODBC Connection Username and Password
Hi experts, I'm trying to save the username and password on ODBC Connection. Is there any easy way to achieve this, so that I can run the SSIS package through SQL Agent Job. Thank you.
June 15th, 2011 7:55am

Hello Suzzane, the answer is no, you cannot. To solve this issue you need to provide the credentials when running the package or use Windows Integrated Security. See how to schedule a package to run using SQL Agent: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx (proxy is very important).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 10:42am

Hi experts, I'm trying to save the username and password on ODBC Connection. Is there any easy way to achieve this, so that I can run the SSIS package through SQL Agent Job. Thank you. Hi, I would recommend you setup your package protection level to EncryptSensitiveWithPassword and then setup your SQL Job Step to include /DE <password> parameter in the command line. The ODBC credentials will stays in place in the package.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
June 17th, 2011 10:32pm

Thanks CozyRoc, My packages are not running via SQL Agent but through Windows Scheduler Task. Also the packages are deployed to SSIS on File System. This is due to Firewall and one of third party liscense tool we use. Also, I tried to use System DSN and password is not saved anywhere. I'm bit lost.
Free Windows Admin Tool Kit Click here and download it now
June 18th, 2011 1:42am

I think this may relate to http://social.msdn.microsoft.com/Forums/en-AU/sqlintegrationservices/thread/77bcd7ae-9afb-4219-80aa-e2f2015c6417Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
June 18th, 2011 2:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics