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: 726
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:
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
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.
© SQL Blog or respective owner