Community

#0397 – SQL Server – SSIS – OLE DB Destination – SEQUENCE can be used only with fast load options

(Nakul Vachhrajani) Traditionally, sequential numbers in a database system were managed by the use of IDENTITY columns. SQL Server 2012 saw the advent of the SEQUENCE object, which can be used to generate a sequence of numeric values according to a user-defined specification.

Read More - Register for Free Membership