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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS DataEffected Records count finding????

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 manner
insert into tablename
select * 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 Package

if 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -