How to create an SSIS Package that reads from a table and exports into an excel sheet

• sanuj

  SSC-Addicted

  Points: 438

  More actions

  September 19, 2008 at 3:20 am

  #125482

  Hi All,

  Please help in in creating an SSIS Package that reads from a table and exports into an excel sheet.

  It would have been nice if you can tell, how we can set it to send the excel file as attachment to one or many recipients automatically....

• Jason Crider

  SSCertifiable

  Points: 6019

  More actions

  September 22, 2008 at 9:38 am

  #875087

  See if this will get you started:

  http://www.sqlservercentral.com/articles/introductiontodtsinsqlserver2005/1486/%5B/url%5D

  The following blog has some good SSIS info:

  http://blogs.conchango.com/jamiethomson/%5B/url%5D

  MCITP, Database Administrator
  A hodgepodge of Information Technology and Life
  LinkedIn Profile
  My Twitter

• sanuj

  SSC-Addicted

  Points: 438

  More actions

  September 25, 2008 at 6:14 am

  #876912

  Thanks 🙂