Error not flowing down Error Precedent Constraint path

I have a dataflow task which keeps erroring, at which point the flow should go down the red path to my error handling SQL Task.

But it is failing to do so.

anyone know why?

What type of transform are you using? (note: task is for control flow not data flow) Have you set up your error output to redirect rows on error? How about for truncation?

etc...

|||

Adolf,

could you explain bettter what is your problem?

You have in eventhandler a SQL task to save the inesperated error, true?

the error is in this SQL Task?

Regards!

|||This is occuring at the Control Flow level.

The design:
A data flow task has two paths coming out of it: 1 green, 1 red.
The green path continues on to another DF task, the red goes to an SQL task.

What happens:
The DF turns red but the flow does not then progress to the SQL task. It just stops.|||What I failed to mention was that the SQL task has 3 other failure paths joining it

I just set the precedence to "OR" instead of "AND" and it works.

Error Message - Server is unavailable

I am running the Report Services website on IIS6 on WIndows 2003.
When I browse to the /reports website on the server, I get a message in big
red letters saying that the server is not avaialbe and that more info is in
the event log of the server.
When I look at the server's Application event log, there are two errors
Source: ASP.NET 2.0.50727.0
EventID: 1073
User N/A
Description: Failed to initialize the Application: /LM/W3SVC/1/root/Reports
Exception: System.IO.FileLoadException
Message: Could not load file or assembly 'System.Web, Version=2.0.0.0,
Culture=neutral, PublicKey Token = b03f5f7f11d50a3a' or one of its
dependencies. Access is denied
<followed by a Stack Trace>
and
Source: ASP.NET 2.0.50727.0
EventID: 1088
User N/A
Description: Failed to execute request because the AppDomain could not be
created.
Error: 0x80070005 Access is denied
What should I be doing to investigate and rectify this error?
Cheers
BobOn Jun 26, 10:07 am, "Bob Miller" <some...@.microsoft.com> wrote:
> I am running the Report Services website on IIS6 on WIndows 2003.
> When I browse to the /reports website on the server, I get a message in big
> red letters saying that the server is not avaialbe and that more info is in
> the event log of the server.
> When I look at the server's Application event log, there are two errors
> Source: ASP.NET 2.0.50727.0
> EventID: 1073
> User N/A
> Description: Failed to initialize the Application: /LM/W3SVC/1/root/Reports
> Exception: System.IO.FileLoadException
> Message: Could not load file or assembly 'System.Web, Version=2.0.0.0,
> Culture=neutral, PublicKey Token = b03f5f7f11d50a3a' or one of its
> dependencies. Access is denied
> <followed by a Stack Trace>
> and
> Source: ASP.NET 2.0.50727.0
> EventID: 1088
> User N/A
> Description: Failed to execute request because the AppDomain could not be
> created.
> Error: 0x80070005 Access is denied
> What should I be doing to investigate and rectify this error?
> Cheers
> Bob
Hi,
for many reason you can get the error message...
Ist of all check your asp.net version of the site...
for this...
open inetmgr.exe and under websites... select your web site...
right click on the site... from option menu select properties...
now in website properties check your asp.net version...
suppose to ASP.net 2.0... if not select asp.net 2.0... and then
save...
Thanks
Masudur
http://munnacs.110mb.com