I have an SSIS 2008 package which contains a number of SQL Tasks and Data Flow tasks with precedence. When I run each of the tasks separately, the transfer is completed, and
sometimes the data flow task turns green, but sometimes it does not. When I run the package as a whole from my workstation, a few of the tasks compete but then all processing stops. There are no errors, the package just sits there. The
objects within the Data Flow tasks are green and the data transfer is completed, but the task is yellow and the package does not move on to the next task.
Each of the Data Flow tasks consists of one ADO.Net Source to an ODBC driver for Cache and an OLDB Destination to a SQL Server database.
I can monitor the source connections and I can see when the successful transfer activity stops. However, the package does not close the connection and move on to the next
I have tried different levels of precedence and even allow all of the tasks to run in parallel and it does not seem to matter.
View Complete Post