Environment : Windows sever 2003, SQL Server 2005
My client send me an .mdb file with tables and query that I have to import in an sql server database.
So I use the "Import data" wizard to do this. My problem is that it's so painfully slow that I think it won't finish. I ran the wizard and it's stuck at the step "Setting SQL Command 57%" since maybe 30min.
So I'd like to know if you have an idea how I can improve this.
EDIT : after a few hours, sql server show me this message :
TITLE: SQL Server Import and Export Wizard
Could not connect source component.
Error 0xc0202009: Source 37 - CRIT_No_swimmingpool : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "System resource exceeded.".
Error 0xc02020e8: Source 37 - CRIT_No_swimmingpool : Opening a rowset for "CRIT_No_swimmingpool" failed. Check that the object exists in the database.
Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)
Any idea ?