My System config if needed
Database: SQL Server 2008
OS:Windows 2008 Server
Microsoft Office 2007
64 bit M/c
I have followed following steps .
1. Added OLEDB Source to configure the Table Or View
2.Then added the Excel destination and Selected Excel 2007
when i check the package after running the package the excel file is in Microsoft Office Excel 97 - 2003
i have gone couple of technical documents.
I need to make changes in OLE DB Source
where i need to select provider as 'Native OLE DB\Microsoft Office 12.0 Access Database Engine OLE DB Provider' and select
Extended Properties=Excel 12.0
My Question,doubt and having problem is i am changing these details in source where a table or view is configured
Confused a lot