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