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]+"'"
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]+"'"
No comments:
Post a Comment