Copy tables and data with column default values
Hello I am trying to use SSIS Transfer SQL Server Object Task to copy tables from one instance to another, but when I try the identity and the default values on the columns are missing on the new tables. I did some research and I found several documents stating that this cannot be done in SSIS. Can anyone tell me a way to accomplish this? I don't want procedures or users, just table data. Thanks
March 24th, 2011 11:42pm

After the object has been transferred script the default like mentioned in http://msdn.microsoft.com/en-us/library/ms173758.aspx and then apply it using Execute SQL task.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
March 25th, 2011 5:35am

Thank you!
March 25th, 2011 6:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics