Templates for SSIS

• SQL_ME_RICH

  SSChampion

  Points: 11200

  More actions

  March 19, 2011 at 11:39 am

  #234333

  Hello - I am wondering is there are templates for SSIS to do things like ETL, working with XML configuration files for sending out form emails, and any other common or complex tasks that can possible be thought of as a starting point for a given project.

  I've been told no such libraries exist for SSIS, but I find that kind of hard to believe (it would be like saying that there is no way to collect T-SQL queries/functions/procedures for future uses as a toolbox).

  Any help on this would be appreciated, as I am new to SSIS.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 21, 2011 at 7:20 am

  #1301284

  There aren't any templates (out-of-the-box), but you can create your own:

  http://support.microsoft.com/kb/908018

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