Friday, July 31, 2009 7:43 AMHi,I'm kinda crazy with my my little problem and i can't figure it out. I use SQL Import Export Wizard and I tried to import all the tables in my Posgresql Database into my SQL Server. I have already setup my ODBC driver and it successfully locate and preview all the data from my Postgresql database. But when i tried to import it, it displays this kind of errorTITLE: SQL Server Import and Export Wizard------------------------------Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider."m_product" -> [dbo].[m_product]:- Cannot find column -1.Please do help me guys. I would really appreciate your help.Best Regards,Nethan
Monday, August 03, 2009 2:56 AMAnswererYou may find more experts about import/export wizard from the forum:
WDAC Team, Microsoft.
Pak-Ming Cheung - MSFT
Wednesday, August 05, 2009 8:14 AMModerator
From the error message you provided, it seems that the cause is the column name you defined in the target tables. In SQLServer, some chars cannot be used as column name directly. For example, -1 in your target table, but it should be [-1] in SQL table.
I suggest that you should change those ambiguous column names in target table and try again.
Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Monday, September 14, 2009 10:28 AMi have same problem ... anyone reslove it ?