How to handle Failed Rows in a Data Flow

Posted on July 16, 2010 by Reza Rad

suppose this scenario: you have a source table and a destination table, you want to transfer rows from source table to destination table, so you can use simple data flow with OLE DB source and OLE DB Destination. but problem hits when destination table has few rows inside, and there is Unique Constraint in ID Read more about How to handle Failed Rows in a Data Flow[…]

Looping through specific files – SSIS

Posted on July 6, 2010 by Reza Rad

As you may know, there is an enuerator in Foreach Loop Container which help you to loop through files, named File Foreach Enumerator. you can specify a location for searching through files and get files as enuerator in loop.But, there are some times which you need to loop through specific files not all of files Read more about Looping through specific files – SSIS[…]