How to produce Auto Incremental Number within SSIS Package

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

Comments & Conversion

Expert

Verified

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.

Related Questions in Database Management System

Q : Data Manipulation Language Illustrates

Illustrates the about Data Manipulation Language?

Q : Explain contexts Explain the term

Explain the term Contexts?

Q : Explain about the Data Storage

Explain about the Data Storage Definition Language?

Q : Expression and aggregator Explain the

Explain the difference between expression and aggregator?

Q : Functions Another company used

Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display