Post reply

Red data flow task but no error to be found ?

  • January 12, 2012 at 7:50 am

    #254871

    Hello,

    I'm using Visual Studio 2008, SQL Server 2008 RS. In visual studio, I've got a couple of data flow tasks linked together by precedence constraint arrows that are set to 'success' before they can continue.

    These tasks simply import data from a Fox Pro db and dump data in a SQL Server db. The problem is that when I execute the package, the 1st

    data flow item goes red and stops the whole process. The thing is that i have debugged and can find nothing wrong with the the process. There are no errors, warnings or messages in the Error list either ? Any ideas ?

    If i change all the precedence constraint arrows to 'completion' instead, the data loads but then all the data flow tasks are red when i run the package.

    Many Thanks in advance

  • January 12, 2012 at 7:55 am

    #1432531

    Have you looked in the Progress tab and found no error messages? Another thing you can do is double-click on the data flow task (while still in debug mode) and it will show you which component failed. This will help you to decide where to focus your investigations.

    John

  • January 12, 2012 at 9:09 am

    #1432633

    Thanks a bunch John ! I found another error msg there and debugged ! 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply