MSSQLTips.com - your daily source for SQL Server tips

Google
 
Web mssqltips.com

ESSENTIALS: Home | Tips | Search | Categories | Top 10 | Products | Authors | Blogs | Forums | Webcasts | Advertise | About
Excel 2007 import slows down SSIS package - MSSQLTips

MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips
Welcome to MSSQLTips Sign in | Join | Help
in Search

Excel 2007 import slows down SSIS package

Last post 07-30-2008 1:40 PM by sqldba. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 07-30-2008 1:40 PM

    • sqldba
    • Top 500 Contributor
    • Joined on 07-30-2008
    • Posts 1

    Excel 2007 import slows down SSIS package

    I am importing tables from an Excel 2007 file to a SQL 2005 db using SSIS on a x64 Vista machine. I've noticed a significant slowdown (Window freeze, long execution time ) in SSIS package execution when importing data from Excel/Access 2007. Is it normal? I know Microsoft Visual Studio 2005 is not compatible with Windows Vista. Could that be the problem? 

    Filed under: ,
Page 1 of 1 (1 items)