December 19, 2013 at 8:14 am
Hello ... I am seeking some help to migrate an Informix table (and eventually an entire database) to MS SQL Server 2012. This is my first experience using SSIS. I started off using the SSIS Import/Export Wizard to create a package. I was actually able to successfully copy a table, but it just didn't copy all the data. It skipped all the data that was in string columns. It created the columns with the proper datatype in the destination table, it just didn't copy the data. The other columns all copied properly. So can anyone tell me if there is something special I need to do to get the string column data to copy? Any help would be greatly appreciated. Thank you...
December 20, 2013 at 7:37 am
Maybe you've done an inappropriate mapping of the columns from the source to the destination.
Take a look on the table in the end of this link http://technet.microsoft.com/en-us/library/ms141036.aspx
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply