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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2014-06-14 : 06:43:18
|
| Hi,I has Created SSIS pkg for Dataloading from Oracle db to Sql server. SSIS pkg has created including DATAFLowtask(incremental tables and full load tables) and Execute SQL task.SSIS pkg has Exeuting through SQL Agent on Schduled basis.we need to know how much data(count of Records affected to Respective table) getting inserting on Incremental tables.executesql task has made below mentioned mannerinsert into tablenameselect * from openquery(select * from tbal where conditon)we need to know how many records has inserted for above statement.Is there any flag kind of mode is available to know the Affected and count of Records in SSIS Packageif anyone know pls explain the way |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-06-21 : 06:06:59
|
| Nope. If ths insertion happens in a execute sql task, then only way is to use another sql task to capture the rowcount. Your table will need to have audit trail columns like datecreated,modifieddate etc for that. If insertion happens inside data flow task you can use rowcount transform for capturing the row count details.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSIS DataEffected Records count finding????