How to produce Auto Incremental Number within SSIS Package

Question

How to produce an Auto Incremental Number within a SSIS Package?

Answer 1

SSIS package doesn’t assist any function to produce auto incremental numbers. Therefore a script component can be utilized for the designated task. The steps are as given below:

• Drag and drop the particular Script Document to the Data flow and choose the Script Component form as Transformation.
• Double click that Script Component.
• Choose the column that is to pass through the script component, into the Input Columns tab.
• Add a column along with an integer data type, within the Inputs and Outputs tab.