Monday 21 July 2014

Create a proxy for ssis package

create a credential with some name say test having your credentials
create a proxy account using same credential in proxies ssis package execution.
While setting up a job set run as that proxy account to execute 

"SELECT  * FROM  ka_eventlog
   WHERE     EventLogID between '"+ (DT_WSTR,15) @[User::minid]+"'  AND '"+ (DT_WSTR,15) @[User::maxid]+"'"