Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Importing data from DB2 to Sql Server 2005 Expand / Collapse
Author
Message
Posted Thursday, March 26, 2009 10:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 15, 2013 8:05 AM
Points: 17, Visits: 63
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

Post #684347
Posted Thursday, October 3, 2013 1:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 5:28 AM
Points: 102, Visits: 1,050
Ensure the missing objects exists in the DB2 database before data transfer to SQL server!

Regards,
Kumar
Post #1501037
Posted Thursday, October 3, 2013 2:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 13,606, Visits: 10,490
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1501043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse