1 / 14

SSIS Tips and Tricks

SSIS Tips and Tricks. Bradley Schacht Twitter: @SQLBS Email: BSchacht@PragmaticWorks.com Blog: www.BradleySchacht.com. About Me. About Me. BI Consultant and Trainer with Pragmatic Works Blogs at BIDN.com Author on a new SharePoint BI Book

tavia
Télécharger la présentation

SSIS Tips and Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SSIS Tips and Tricks Bradley Schacht Twitter: @SQLBS Email: BSchacht@PragmaticWorks.com Blog: www.BradleySchacht.com

  2. About Me

  3. About Me • BI Consultant and Trainer with Pragmatic Works • Blogs at BIDN.com • Author on a new SharePoint BI Book • Has spoke at past events like User Group, Code Camps, and SQL Saturdays • Trained Brian Knight to bark on command • Microsoft Copy & Paste MVP • It’s touted as the cure for insomnia • The bathroom really appreciated the session

  4. Overview Naming Conventions Checkpoints Error Logging Transforms

  5. Module 1 Naming Conventions Make them! Use them! Help in error logging

  6. Module 1 Demo

  7. Module 1 Checkpoints Mark where SSIS package fails Logs the package state Restart from the point of failureDon’t use in production

  8. Module 1 Demo

  9. Module 1 Error Logging Failure precedence constraints SQL Task or Email Why rebuild the same logging? Reusable event handler

  10. Module 1 Demo

  11. Module 1 Transforms Fully blocking Partially blocking Non-blocking Do it in the source not SSIS

  12. Module 1 Demo

  13. Overview Naming Conventions Checkpoints Error Logging Transforms

  14. Questions and Comments Bradley Schacht Email: Bschacht@PragmaticWorks.com Twitter: @SQLBS Blog: www.BradleySchacht.com

More Related