Enforce SSIS naming conventions using BI-xPress

Posted by jamiet on SQL Blog See other posts from SQL Blog or by jamiet
Published on Thu, 10 Oct 2013 08:10:03 GMT Indexed on 2013/10/17 22:08 UTC
Read the original article Hit count: 394

A long long long time ago (in 2006 in fact) I published a blog post entitled Suggested Best Practises and naming conventions in which I suggested a bunch of acronyms that folks could use to prefix object names in their SSIS packages, thus allowing easier identification of those objects in log records, here is a sample of some of those suggestions:

SNAGHTMLf8e56b8

If you have adopted these naming conventions (and I am led to believe that a bunch of people have) then you might like to know that you can now check for adherence to these conventions using a tool called BI-xPress from Pragmatic Works. BI-xPress includes a feature called the Best Practices Analyzer that scans your packages and assess them according to some rules that you specify. In addition Pragmatic Works have made available a collection of these rules that adhere to the naming conventions I specified in 2006

image

You can download this collection however I recommend you first read the accompanying article that demonstrates the capabilities of the Best Practices Analyzer. Pretty cool stuff.

@Jamiet

© SQL Blog or respective owner

Related posts about naming conventions

Related posts about sql server integration se