posted on Thursday, January 05, 2006 1:50 PM
by
bknight
Great SSIS Best Practice Post
Jamie Thomson has posted a great blog post about SSIS development best practices. I love his naming standard idea:
http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx
Jamie recommends that you prefix each task or transform with a prefix that indicates what type of task or transform it is. For example, if you have a task that loads an inventory table, you would call the Data Flow task "DFT Load Inventory". This obviously would not help you at design time as you can see by the icon what type of task it is. It would however help you and the operations folks at your company would be able to track down what type of task failed easily. For example, if you use a log provider of some sort to output all the events, the Source Name will show the task type versus just Load Inventory (and the ops guy wouldn't know what this task is).
-- Brian Knight