Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Transformation Rss

   Items 1 to 2 of 2   
 

Semi-blocking Transformations in SQL Server Integration Services SSIS

In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking transformations in SSIS.  Read more...
Rating:  Rate this |   Briefcase | 1,984 reads

Using SSIS to Capture the File Name

This article will show how to use SSIS to capture the file name during the load process and later remove bad data from your warehouse. New Author J.D. Gonzalez has an interesting approach that you might find useful.  Read more...
Rating: |  Discuss |   Briefcase | 14,890 reads
   Items 1 to 2 of 2   
 
Tags
integration services (ssis) (2)    
etl (1)    
flat file connection (1)    
for each task (1)