I am using SQL import/export wizard to import a table from oracle, SQL wizard is generating the following error.
TITLE: SQL Server Import and Export Wizard ------------------------------ Could not connect source component. Error 0xc0202009: Source - PORTRAIT [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Error 0xc02020e8: Source - PORTRAIT [1]: Opening a rowset for ""FLDADMIN_TEST"."PORTRAIT"" failed. Check that the object exists in the database. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
Although I can import other table without any problems. I noticed that Portrait table is partitioned, if this is the problem?how can I import such table?
Thank you, Ihab