tristonyip
asked on
SSIS package run on sql job
hi
i try to run a SSIS package on sql server 2005, the package runs on SSIS, but when i put into server and run from the server i got ConnGetProxyPassword error,
i create a Proxy account, it's my network ID, and i have admin rights on the server, thanks for your help.
i try to run a SSIS package on sql server 2005, the package runs on SSIS, but when i put into server and run from the server i got ConnGetProxyPassword error,
i create a Proxy account, it's my network ID, and i have admin rights on the server, thanks for your help.
Hi,
you can check my below article to run ssis package from SQL agent using proxy.
https://www.experts-exchange.com/Database/MS-SQL-Server/A_8452-Execute-SQL-Job-with-Proxy.html
you can check my below article to run ssis package from SQL agent using proxy.
https://www.experts-exchange.com/Database/MS-SQL-Server/A_8452-Execute-SQL-Job-with-Proxy.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this works finally.
this kb should help: http://support.microsoft.com/kb/918760