up vote 0 down vote favorite
share [g+] share [fb]

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 ?

link|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. – DJ Pon3 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
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.