SSIS – Beginner’s Walkthrough
session will step the attendees through the basics of SSIS by setting
up a sample solution to import data from a variety of sources. We will
look at some of the more common control flow tasks as well as the
various components of the data flow task. The sample solution created
will be based, at least in part, on questions from the audience.
SSIS – A Beginning Framework
Most developers would agree that every SSIS solution will have the same
fundamental outline. A basic framework will expedite the process by
handling the common tasks between the systems while allowing the
developer to concentrate on the task at hand. This framework will
consist of many items, including but not limited to setting up package
configurations, logging, audit trails, error handling, naming
standards, etc. This session will present an example framework which
can be used as the basis for future SSIS Package development.
I have recently done a talk similar to the beginning framework at work and it went OK. I think that I learned a few things from that which will help me in my presentation for the conference. I should get some notes out on my audit subsystem, framework variables, etc out in the next few weeks as blog entries for anyone who is interested.