How to create Excel File Based on Tables in SSIs

• tariqueiqbal 68459

  SSC Rookie

  Points: 27

  More actions

  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

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  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