I am writing to a flat file destination in a 2008 SSIS package. 99.99% of it works correctly. However, I get one duplicate record in the destination file.
Here is the basic flow of the package:
1. Read two ISO-8859-1 encoded files and encode their text to UTF8 in memory
2. Combine the two files together in memory and load them into a lookup cache
3. Read another source file from disk
4. Match an ID column
View Complete Post