Designing an SSIS Framework

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Presentations and Speaking » Designing an SSIS Framework

Designing an SSIS Framework

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Leonard

Posted Monday, January 24, 2011 10:51 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:27 PM
Points: 375, Visits: 950

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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1052564

Evil Kraig F

Posted Monday, January 24, 2011 10:58 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:35 PM
Points: 5,722, Visits: 6,194

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1052570

Andy Leonard

Posted Monday, January 24, 2011 11:06 AM

Old Hand

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:27 PM
Points: 375, Visits: 950

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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard

Post #1052581

Evil Kraig F

Posted Monday, January 24, 2011 11:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:35 PM
Points: 5,722, Visits: 6,194

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?

Post #1052587

« Prev Topic | Next Topic »

Permissions