How to Generate an Auto Incremental Number in a SSIS Package?
Submitted by: AdministratorSSIS 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SSRS Job Interview Questions And Answers
Top SSRS Questions
☺ | Explain the architecture of reporting services? |
☺ | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |
☺ | What are the ways to tune Reporting Services? |
☺ | Describe Reporting Lifecycle? |
☺ | What can SQL Server Reporting Services do? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |