When you execute these packages, you often see some temporary files been created / deleted on your physical drives. are good examples of a blocking transformation. A Sort / Aggregate/ Fuzzy Lookup transformations etc. In simpler terms, a blocking transformation is a one which must read and process all input records before creating any output records and thus has a great impact on the performance of a SSIS package execution. When I say a COMPLEX – SSIS package, what I really mean is a SSIS Package that contains a couple of blocking transformations. Through the use of this blog, I would like to address a common scenario that you would run into when executing a complex SSIS package from within the BIDS environment in a 圆4 bit development server, where the visual studio- BIDS environment goes to a hanged state during the package execution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |