Post reply

Looking for generic SSIS Standards doc

  • June 6, 2007 at 1:53 pm

    #176979

    Would anyone be willing to share their generic set of SSIS Standards?  (eg. Naming Conventions for the various SSIS Objects, Configuration parms, Logging, Error Handling, Deployment, etc..)

    I've been tasked w/ the mundane effort to pull together an initial set of SSIS Standards.  Of course, I'll customize to our environment

    thanks in advance.

    BT

  • June 6, 2007 at 3:08 pm

    #711253

    I'll check with my co-worker. He does a lot of our SSIS package development and we have talked about standards, but I don't know if we ever got to the point we had it documented in writing.

  • June 7, 2007 at 5:24 am

    #711370

    Lynn - anything is appreciated.  thx

    BT

  • June 7, 2007 at 4:55 pm

    #711551

    I checked with my co-worker.  We have discussed the standards we are using, and have some rough notes written down, but unfortunately, we have had the opportunity to formalize the doc as of yet.  I will keep you in mind as we continue working on our DW project as I do know we want to get that stuff formalized for future employees that may have to work on this project down the road.

  • June 14, 2007 at 11:20 pm

    #713133

    Hi .. were you able to pull off the doc for the SSIS standard conventions ? I have been assigned with the same task as well and was wondering if you could help me out :blink:

  • June 15, 2007 at 6:49 am

    #713232

    Unfortunately, no.  If I come across 1, I'll reply.

    BT

  • June 15, 2007 at 8:19 am

    #713261

    Here's a blog which outlines some "standards"

    http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply