Importing data from DB2 to SQL server RRS feed

  • Question

  • Hi,

    I'm new to SQL server. My huge data is there in DB2. I tried to import using SSIS import/export wizard, it does successfully with default datatype columns.


    for example, If my DB table has numeric columns, it has been imported as "double" and if it is string, it has been impoerted as "nvarchar". Is there any way to have correct/equivalnet datatype import from DB2?




    Wednesday, May 23, 2007 6:59 AM

All replies