data transformation services in sql server

Improving ETL Performance by Avoiding Asynchronous Transformations

While performance tuning your SSIS package, you may often find that the transformations in your data flows take a long time to complete. One way to improve performance is to avoid asynchronous transformations.