locked
SSIS 2012 Development Standards RRS feed

  • Question

  • So I've been asked to put together and document detailing Standards and Best Practices for SSIS 2012.  Can someone repoint me to a document that details this?  Much appreciated!
    Wednesday, September 24, 2014 1:13 PM

Answers

  • I better refer you to a very good blog post:

    Top 10 SQL Server Integration Services Best Practices

    http://blogs.msdn.com/b/sqlcat/archive/2013/09/16/top-10-sql-server-integration-services-best-practices.aspx


    Arthur

    MyBlog


    Twitter

    Wednesday, September 24, 2014 1:48 PM
  • Hi,

    You can use below link;

    http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/29/suggested-best-practises-and-naming-conventions.aspx

    Thanks


    Please Mark This As Answer or vote for Helpful Post if this helps you to solve your question/problem.

    Wednesday, September 24, 2014 2:24 PM
  • Hi Diango,

    Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. We use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

    SQL Server Integration Services (SSIS) has grown a lot from its predecessor DTS (Data Transformation Services) to become an enterprise wide ETL (Extraction, Transformation and Loading) product in terms of its usability, performance, parallelism etc. Although the internal architecture of SSIS has been designed to provide a high degree of performance and parallelism there are still some best practices to further optimize performance.

    References:
    SQL Server Integration Services SSIS Best Practices (Four parts)
    SQL Server Integration Services (SSIS) 15 Best Practices

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Thursday, September 25, 2014 11:09 AM

All replies

  • I better refer you to a very good blog post:

    Top 10 SQL Server Integration Services Best Practices

    http://blogs.msdn.com/b/sqlcat/archive/2013/09/16/top-10-sql-server-integration-services-best-practices.aspx


    Arthur

    MyBlog


    Twitter

    Wednesday, September 24, 2014 1:48 PM
  • Hi,

    You can use below link;

    http://sqlblog.com/blogs/jamie_thomson/archive/2012/01/29/suggested-best-practises-and-naming-conventions.aspx

    Thanks


    Please Mark This As Answer or vote for Helpful Post if this helps you to solve your question/problem.

    Wednesday, September 24, 2014 2:24 PM
  • Awesome!  Thank you so much guys!  This will really help me in completing this assignment.
    Wednesday, September 24, 2014 3:10 PM
  • Hi Diango,

    Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. We use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

    SQL Server Integration Services (SSIS) has grown a lot from its predecessor DTS (Data Transformation Services) to become an enterprise wide ETL (Extraction, Transformation and Loading) product in terms of its usability, performance, parallelism etc. Although the internal architecture of SSIS has been designed to provide a high degree of performance and parallelism there are still some best practices to further optimize performance.

    References:
    SQL Server Integration Services SSIS Best Practices (Four parts)
    SQL Server Integration Services (SSIS) 15 Best Practices

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Thursday, September 25, 2014 11:09 AM