sql server 2008 - SSIS Job did not run properly -
i have built ssis package exec sp in sql 2008. when run package bids, generates results insert table (took 1 min). when scheduled run agent job in sql took 2-3 sec no results produced, table empty, job history came succeeded. know how debug situation? help.
try debugging sql profiler. start trace, , kick off sql agent job, , see being executed.
Comments
Post a Comment