Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Designing an SSIS Framework Expand / Collapse
Author
Message
Posted Monday, January 24, 2011 10:51 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
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
Posted Monday, January 24, 2011 10:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:08 PM
Points: 5,401, Visits: 7,514
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
Posted Monday, January 24, 2011 11:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:15 PM
Points: 388, Visits: 1,044
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
Posted Monday, January 24, 2011 11:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 23, 2014 6:08 PM
Points: 5,401, Visits: 7,514
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1052587
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse