sql server 2008 - Report rowcount to SQL AGENT from Execute SQL task in SSIS package -

sql server 2008 - Report rowcount to SQL AGENT from Execute SQL task in SSIS package -

i have number of ssis packages run net alter import processes 1 database another. @ destination server info inserted temp table info flow task, , run simple set of net alter insert/update/delete queries in execute sql task.

i'd study number of rows inserted, deleted , updated sql agent - i'd these counts show in "view history" interface in ssms jobs running ssis package.

i sense should incredibly simple (and it's no uncertainty going turn out be), can't work out how it.

i'm running sql server 2008 r2

it's working cmdexec , t-sql job type. give seek ssis job type.

in execute sql task, store count of updated/inserted/deleted rows. utilize print statements in task. go new job => steps => new => under new job step click advanced pane, , check "include step output in history" checkbox.

sql-server-2008 ssis