Importing rows from SQL Server to Excel 2007 using SSIS

  • 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

  • Please refer this if any body has problem with this kind of issue.

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ef9fda20-4948-4e3d-920c-3cee07b55ed3?prof=required

  • That's a pretty long thread. Can you mark one of the posts as the accepted answer so people will know what there specifically fixes the issue without having to retrace all your steps?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply