August 30, 2012 at 6:59 am
my excel file has xlsx version.
and i am using visual studio 2005.
it gives me error at excel source connection. what version do i need to choose.
August 31, 2012 at 12:07 am
Either convert to 2003 Excel, .xls, or use the following method:
Using Excel 2007 files as a Source in SSIS 2005[/url]
Or upgrade to a recent version of SSIS, that's also an option.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy