Post reply

How to create Excel File Based on Tables in SSIs

  • February 21, 2012 at 11:51 pm

    #265031

    HI All,

    Small help needed.

    SSIS can i generate Excel data files dynamically.

    I have 3 tables in my database.

    Table_1

    Table_2

    Table_3

    I need to generate 3 excel files with file names same a table names but with .xlsx extension

    Can anyone help me out on this regard.

    Thanks in Advance.

    Tarique

  • February 21, 2012 at 11:59 pm

    #1450074

    Set up 3 different dataflows with each it's own Excel destination and it's own Excel connection manager. Make sure you select 2007 in the connection manager to have the .xlsx extension.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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