Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2008-12-05 : 14:11:19
|
| Sir i have a Procedurein which i am update , delete & insert records .Now i am creating a SSIS package in which i want to count Affected ( Delete,Insert , Update ) RowsHow can i Do this .................Pls help me out .........................Yaman |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 14:14:24
|
| Use Rowcount transformation task or@@rowcount |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-06 : 00:09:46
|
quote:
Originally posted by yaman
Sir i have a Procedurein which i am update , delete & insert records .Now i am creating a SSIS package in which i want to count Affected ( Delete,Insert , Update ) RowsHow can i Do this .................Pls help me out .........................Yaman
are you performing these inside procedure called from ssis execute sql task or inside ssis data flow directly? |
|
|
|
|
|
|
how to count insert & delete & update rows