Importing data from DB2 to Sql Server 2005

• abr_mah

  SSC Enthusiast

  Points: 161

  More actions

  March 26, 2009 at 10:35 am

  #198594

  dear all,

  plz i need your help ,

  i want to import data from DB2 to Sql server 2005.

  i was trying it but it generate an error .

  "

  - Setting Source Connection (Error)

  Messages

  Error 0xc0202009: Source - ABDO [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

  (SQL Server Import and Export Wizard)

  Error 0xc02020e8: Source - ABDO [1]: Opening a rowset for ""test"."ROOT"."ABDO"" failed. Check that the object exists in the database.

  (SQL Server Import and Export Wizard)

  Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)

  "

  please urgent

  thanks,

  best regards

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  October 3, 2013 at 1:56 am

  #1655430

  Ensure the missing objects exists in the DB2 database before data transfer to SQL server!

  Regards,
  Kumar

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  October 3, 2013 at 2:04 am

  #1655436

  KumarSQLDBA (10/3/2013)

  ---

  Ensure the missing objects exists in the DB2 database before data transfer to SQL server!

  I sure hope that guy solved his problems 4 years ago 😉

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP