SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQLLunch and SQL University have Combined Forces - SSIS Tips & Tricks (Advanced SSIS)

The SQL Lunch and SQL University have combined forces.  Come and watch, laugh, and learn.

SQL UniversitySQL Lunch

#48-SSIS Tips&Tricks (Advanced SSIS)

Lunch Image

Speaker: Josef Richberg

Add To Outlook: Add To Calendar

Date and Time: 1/28/2011 11:30:00 AM CST

BIO: A SQL practitioner for over 17 years specializing in performance & tuning. I currently work for Harpercollins Publishers designing, enhancing, and improving, the sql experience for many of the data warehouse applications. I have been heavily involved in designing and implementing SSIS packages. I am the RedGate '2009 Exceptional DBA' awards winner

Topic: #48-SSIS Tips&Tricks (Advanced SSIS)
Learn some of the quirks and capabilities of SSIS. Learn about the pitfall of "parallel path choicing". Use the Script Component as a data source (to solve complex sourcing issues) and as a data destination (to get around the identity column conundrum). See how use Script Tasks to build directory scanners for efficient file import techniques. We'll also go over some the tunable properties of the Data Flow object.


Talk to you soon,

Patrick LeBlanc, MVP, MCTS

Founder www.SQLLunch.com




No comments.

Leave a Comment

Please register or log in to leave a comment.