Home Forums SQL Server 2005 Business Intelligence Import Excel binary files into SQL Db using SSIS RE: Import Excel binary files into SQL Db using SSIS
jeffstubing
Valued Member
Points: 70
More actions
March 21, 2016 at 8:51 am
#1866486
Thanks Lady. I was able to set up the Excel Connection Manager doing this, but when I go into the Excel Source task to select my columns I get a "File is not in the expected format" message. :angry: Any idea how to beat this?