Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

Thanks

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 [1957]: 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 [1957]: Opening a rowset for "CRIT_No_swimmingpool" failed. Check that the object exists in the database.


ADDITIONAL INFORMATION:

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


BUTTONS:

OK

Any idea ?

share|improve this question
    
I'm not too sure you can "improve" this. It's importing a proprietary database structured in a totally different way into SQL Server. I hate to say it but be glad you can import it at all. About all I can suggest is that you run the access compact and repair routine prior to the import, but I doubt it will make much difference. –  RobM Jan 26 '11 at 10:32
    
I agree with you but still ,I think there is a problem : it's still at 57%, there must be something causing this. –  remi bourgarel Jan 26 '11 at 10:37
    
what do you mean tables AND query? you get a query that you run over the tables for the data that needs to be imported? how big is the mdb file? how many rows are you importing? –  Nick Kavadias Jan 26 '11 at 13:12
    
The .mdb weight 700MB. There is some query in the .mdb that I need to import as table in access. There is around 30 table with a maximum of 300 000 rows in one table (the other are less than 10 000) –  remi bourgarel Jan 26 '11 at 13:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.