Post reply

Export To Excel

  • September 25, 2012 at 4:02 am

    #267237

    Hi Guys,

    I am new to SSIS,Could you please help me to implement(step by step) below task.

    Task:

    I need to export data returned from storedprocedure to new(dynamically created) excel file in specific folder.

    Thanks and Regards,

    Ningaraju N E

  • September 25, 2012 at 4:24 am

    #1541756

    create a data flow task

    drag in a ole-db ado.net source connector, up to you which

    drag in an excel destination connector

    create the connection strings in both of the connectors to the database and to the excel file

    set the source connector to run the stored proc

    drag the line between the two connectors

    run the package.

  • September 25, 2012 at 4:44 am

    #1541771

    Thanks,Can I get better link for the same?

  • September 25, 2012 at 4:47 am

    #1541775

    Take a look in the stairways section, for the stairway to integration services also there is plenty on the internet if you use a defined search term like using ssis to export to excel

  • September 25, 2012 at 8:48 am

    #1541916

    One other thing you might want to try. Use the 'Export Data' function in SSMS to export something from SQL Server to an excel spreadsheet. Be sure to save the package that is auto created.

    When you've finished with the wizard, examine the saved package. That will give you an idea of how to build a package to export to excel. You'll want to take a good look at the SQL Task used to create the excel spreadsheet. It's a step that's needed before the data flow so that you have the excel spreadsheet to receive the data.

    Added:

    You'll also want to check the data flow. You'll find that there is a data conversion that's needed for preparing the data to be handled by excel data types.

Viewing 5 posts - 1 through 4 (of 4 total)

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