Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Export to access extremely slow

Author  Topic  kenik Starting Member 1 Post Posted - 2010-06-24 : 13:22:35 Hi all, I'd appreciate very much if someone could answer my question bellow. I created an SSIS package using the Export and Import wizard that exports some tables from SQL server to Access. The problem is that it's an extremely slow process for a table with just 200.000 rows. I guess it may take up to 30 minutes while exporting to a flat file takes 10 seconds! Again, any help is appreciated, even if in other technology. Thank you!!