none
Postgresql to SQL Server 2008 RRS feed

  • Question

  • Hi,

       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 error

    TITLE: 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
    • Moved by Jonathan KehayiasMVP Saturday, August 1, 2009 6:12 PM Data Import question (From:SQL Server Database Engine)
    Saturday, August 1, 2009 4:38 PM

Answers

  • Hi,

    The error message shows that SSIS can't convert the datatype between Postgresql and SQL 2008. What did you set for this column? Try to adjust it.

    Thanks.
    Yao Jie Tang -Microsoft Online Community
    • Marked as answer by Tony Tang_YJ Tuesday, August 25, 2009 8:54 AM
    Monday, August 3, 2009 6:44 AM