SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export to Access is real slow
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

taunt
Posting Yak Master

116 Posts

Posted - 06/06/2013 :  12:16:03  Show Profile  Reply with Quote
Hello I use to be on sql server 2005 (native client 9), now I'm using sql server 2008 (native client 10). The exporting a table to Access now takes 5 times as long to export. I can use sql manager 2005 to export the table, but that's a pain. Is there a way I can update the table to be more friendly exporting in sql 2008? What is the issue that might be causing this?

Thanks

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 06/07/2013 :  01:58:36  Show Profile  Reply with Quote
whats the size of the table? are you using export import wizard?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

taunt
Posting Yak Master

116 Posts

Posted - 06/07/2013 :  11:39:59  Show Profile  Reply with Quote
Sorry I don't know how to get the size in gigs out the table, but it's 878388 rows and about 20 colums. The export is usually arounf 2 gigs. I'm using the wizard at the moment. Later I plan on making a ssis package.

Edited by - taunt on 06/07/2013 12:01:03
Go to Top of Page

taunt
Posting Yak Master

116 Posts

Posted - 06/07/2013 :  18:25:00  Show Profile  Reply with Quote
I think it's a 32 bit vs 64 bit thing. I'm exporting to a 32 bit Access file from a 64 bit SQL Server. Would that be the speed issue?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 06/08/2013 :  03:21:25  Show Profile  Reply with Quote
not any direct influence i would say. check if you've a better provider to connect to access

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000