Designing an SSIS Framework

  • In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Andy,

    For those of us un-hip in the new termonology, this is just basically environmental configuration usage, right?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Hi Craig,

    Yes.*

    :{> Andy

    *There's more to it than that. It includes a discussion of when to use which configuration options and how to combine them so you can migrate SSIS packages from server-to-server (Dev-to-Prod, for example) and not have to open the package to edit connection strings for Connection Managers. I do not demonstrate the only way to do this, as there are several permutations. I demonstrate a way that, although complex, works in most places.

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Cool, okay. Some of your other brief descriptions contain verbage that I have to translate in my head to think if I know what you're talking about. Are you purposely avoiding mentioning the more common terminology from MS itself?


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

Viewing 4 posts - 1 through 3 (of 3 total)

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