I have a data load from a csv file to a database via an SSIS package. When I run the package it fails. My question is that on the Control Flow panel the data source is green (i.e. success) and the data destination is red (i.e. failure). Then on the data flow page the data souce and data destination boxes are both yellow (i.e. in process). Additionally on the data flow page the next to the detination arrow it reports a number that must be the number of rows that have flowed from the source to destination. So to me it must mean that the next row is where the error occurs? Specifically I am trying to load 1450 records and the data flow page shows the number of 748. Unfortunatalty when I check the data I can not find any issues with row 748 and for that matter any row.