THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » excel » SSIS Snack   (RSS)
  • SSIS Snack: SSIS, Excel, and a 64-bit OS

    Let's say you want to load data from an Excel 2003 (.xls) file into a database using SSIS: If you're running on a 64-bit machine, you'll get this:   Plus this error: [PASS Regional Mentor Spreadsheet [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 19, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement