• I'm not good with HTML, so I sent the pictures via email to you. Does this help?

    "Hope this isn't too big for your email, but I don't really know how to explain where this 'transform' option is. After you open the DTS wizard, you enter the connect info for the source and destination servers. Then you choose copy tables option. Then you get this first screen. When you place a checkmark next to a table you want to copy, the third column becomes active and when you hit the ellipsis button, you will see the second picture where you can choose the 'enable identity insert' option."



    Michelle