SSIS-導入Excel文件時記錄行號

SSIS導入Excel時記錄行號

1. "Excel源"後添加"腳本組件"

2. "腳本組件"中新增輸出列,命名為"RowNumber"

3. "腳本組件"中編輯腳本.

4. 腳本如下.

private
				int m_rowNumber;

       m_rowNumber++;

       Row.RowNumber = m_rowNumber;

5. 下一步的輸入列中顯示RowNumber

6. 結果.

參考鏈接:

1. https://support.microsoft.com/en-us/help/908460/how-to-add-an-incremental-counter-in-a-sql-server-2005-integration-ser

2. https://www.hansmichiels.com/2015/11/13/how-to-add-a-rownumber-to-a-data-flow-task-in-ssis-2012/