Link to home
Start Free TrialLog in
Avatar of tristonyip
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.
Avatar of prequel_server
prequel_server

having admin rights on the server does not always mean you have admin rights in SQL Server. If your AD/network id was not added as an admin during sql server installation then you may not have full admin rights.

this kb should help: http://support.microsoft.com/kb/918760
Avatar of Alpesh Patel
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
ASKER CERTIFIED SOLUTION
Avatar of tristonyip
tristonyip

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tristonyip

ASKER

this works finally.