I try to create a SSIS package and want to setup the Excel connection. Here are what I did:
1. right click the Data Source
2. Select "new" connection
3. Look for Excel in the provider.
However, i just cannot see any Excel connection in the list. Anyone can show me where it is?
BTW, I use BIDS 2008.
Thanks a lot in advance.