如何在SSIS日志表中添加rowcount变量 [英] How to add rowcount Variable in SSIS log table

问题描述

嗨我只需要三件东西

套餐开始时间，

套餐结束时间和

生成的行数，



软件包的开始和结束时间由jst记录，允许使用SSIS Log Provider for SQL Server和详细事件进行日志记录;我没有选择任何东西。



现在我想添加显示最终总行数的列或行。



i已经创建了行计数转换框并分配给了一个变量，但是如何添加到我现有的SSIS日志表中。

谢谢



i希望像这样的输出（列）或



ID |活动|来源| 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





或像这样的输出（行）



ID |活动|来源| StartTime | EndTime |伯爵

----------------------------------------- ------

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

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

推荐答案

我找到了这个 [ ^ ]。

这篇关于如何在SSIS日志表中添加rowcount变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！