问题描述
嗨我只需要三件东西
套餐开始时间，
套餐结束时间和
生成的行数，
软件包的开始和结束时间由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变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！