Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
hi i only need three things
package start time,
package ending time and
numbers of rows generated,

package start and end time was recorded by jst enabling logging with SSIS Log Provider for SQL Server and in details events; i selected nothing.

now i want to add column or row that displays total final rows generated.

i already have created row count transformation box and assigned to a variable, but how to add to my existing SSIS log table.
Thank you

i want like this output(Column) OR

ID | Event | Source | StartTime |EndTime | @RowCount
-----------------------------------------------
1| PackageStart | myPackageName|2014-10-01 |2014-10-01 | 10,000
2| PackageEnd | myPackageName|2014-10-01 | 2014-10-01 | 10,000


OR Like this output (Row)

ID | Event | Source | StartTime |EndTime | Count
-----------------------------------------------
1| PackageStart | myPackageName|2014-10-01 |2014-10-01 | NULL
2| PackageEnd | myPackageName|2014-10-01 | 2014-10-01 | NULL
3| RowCount | myPackageName|NULL | NULL | 10,000
Posted

1 solution

I found this[^].
 
Share this answer
 
Comments
MAbubakar.Riaz 9-Jan-14 21:48pm    
thnx bro but i want it to add in Table i.e dbo.sysssislog
i already googled that link
MAbubakar.Riaz 9-Jan-14 21:50pm    
christan do you want me explain more if u didnt understand my need??
Christian Graus 9-Jan-14 21:56pm    
http://www.sqlsafety.com/?p=272 ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900