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 : What is middleware applications Explain

Explain middleware applications which ease the connection of databases to Web applications?

Q : What is concurrency transparency Write

Write down a short note on the term concurrency transparency?

Q : Differences between vertical and

Write a short note on the differences between vertical and horizontal portioning?

Q : Improvement in Automation-Cloud

Improvement in Automation: Cloud computing is designed and coded to perform a lot of operations by itself. It has been designed to operate in a completely automated fashion. It enhances the efficiency of the organization.