The SQL Lunch and SQL University have combined forces. Come and watch, laugh, and learn.
Speaker: Josef Richberg
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