SSIS Tips and Tricks Q&A

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

1 Response

  1. Test User says:

    In your answer to “What are some examples of partially blocking transforms?” you classify the various transformations.

    1) You did not classify the following transformations:
    – Balanced Data Distributor
    – DQS Cleansing

    2) The Script Component may be non-blocking or not. MSDN has articles showing how to write a synchronous or an asynchronous Script Component.

Leave a Reply