chuang4630
asked on
Where so I find the Excel connection manager in SSIS
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will try
Great, thanks for the points and see you in another SSIS question, by the way I blog helpful SSIS/SSRS stuff at http://asqlb.blogspot.com/ consider taking a look and following :)
Regards,
Jason Yousef
Regards,
Jason Yousef
Untitled.png