SQL Server Reporting Services Question:
How to Generate an Auto Incremental Number in a SSIS Package?
Answer:
SSIS package does not support any function to generate auto incremental numbers. A script component can be used for the designated task. The steps are as follows:
1. Drag and drop the Script Document to the Data flow and select the Script Component Type as Transformation.
2. Double click the Script Component.
3. Select the column which is to pass through the script component, in the Input Columns tab.
4. Add a column with an integer data type, in the Inputs and Outputs tab.
1. Drag and drop the Script Document to the Data flow and select the Script Component Type as Transformation.
2. Double click the Script Component.
3. Select the column which is to pass through the script component, in the Input Columns tab.
4. Add a column with an integer data type, in the Inputs and Outputs tab.
| Previous Question | Next Question |
| How to schedule SSAS Database backup. | Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose? |