how to generate an auto incremental number in a ssis package?



how to generate an auto incremental number in a ssis package?..

Answer / Srijan Srivastava

In SSIS (SQL Server Integration Services), you can use the OLE DB Source and Script Component transformations to generate an auto-incrementing ID. Here's a simplified example: 1) Create a new table with a column for the auto-incrementing ID, set the ID as an identity column; 2) Use OLE DB Source to read data from this table; 3) Modify the Script Component to generate the next value and update the table; 4) Reuse the OLE DB Source to read the updated ID.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

1 Answers  


Which is best database?

1 Answers  


Is it good to store image in database?

1 Answers  


What is the example of rdbms?

1 Answers  


describe and contrast a trigger and a procedure.

1 Answers  


can Constraints cannot be exported through EXPORT command ?

2 Answers   Grasim, Oracle, Suvidha,


How to select a random record from a table?

1 Answers  


What is On-line Redo Log?

2 Answers  


Which database is best for storing images?

1 Answers  


Explain data independence?

1 Answers  


what are the advantages of a client or server model ?

1 Answers  


Who is communication horizons?

1 Answers  


Categories