Andy Leonard

THE SQL Server Blog Spot on the Web

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

Home

Blogs

Downloads

Opml

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

Browse by Tags

All Tags » x64 » Excel (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. Read More...

Posted Tuesday, January 19, 2010 8:00 AM by andyleonard | 11 Comments