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