SSIS keep autonumeric field values when transfering object (table)

  • Hello, im new here.

    Now this is my problem:

    how to using SSIS Transfer SQL Server Objects Task transfer a db keeping the autonumeric values..

    the problem is that in source a field named ID is identity but some registers has been deleted so even when I got 60 rows some of them has numbers greater than that, well when I make the trasfer the new created table (or replaced) in destiny has a ID field created from scratch and has perfectly correlative numbers there.

    how is the rigth way to do things in this case?

  • Let me restate the problem to make sure I understand it. You are copying table data from one database to another using SSIS. The table includes an identity column. There are gaps and islands in the number sequence for the identity column, and you need to make sure these are properly duplicated in the copy.

    Gaps and Islands are inevitable in identity columns. The only practical solution, in my experience, is to not make that particular column an identity column in the duplicate table. Just make it a regular integer column and copy the data from the source table as you would any other column.

    By the way, this applies no matter how you copy the data.

  • thansk, I did that way.

    another question, in the same scenario, if one column is an encrypted password would be that data well copied? Im having probems wiht passwords copied as they are encrypted i cant tell if they are allright onlly when trying to use them to log they are failing.. so im suspecting that they have being copied wrong.

    (by the way sorry for my bad english)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply