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 |
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
Which is best database?
Is it good to store image in database?
What is the example of rdbms?
describe and contrast a trigger and a procedure.
can Constraints cannot be exported through EXPORT command ?
2 Answers Grasim, Oracle, Suvidha,
How to select a random record from a table?
What is On-line Redo Log?
Which database is best for storing images?
Explain data independence?
what are the advantages of a client or server model ?
Who is communication horizons?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)