Ben,

Thanks for the feedback. I had never really thought of using SSRS on the front of the query. I actually am not comfortable enough with XML know how...

Thanks Andy. Just read and commented on your blog post on Developer Communities: The Team Builder. It is a...

Craig,

You can use the script component as the error destination after any transformation (that has an error output) within the data flow. Then I immediately insert into the...

Great, glad you got it figured out and that the article was helpful.

Thanks for the nice comments thus far.

steitelbaum,

What browser are you using? I have used both Firefox 2.0.0.14 and IE 7.0.5730.11 and the code sections are wide and readable. ...

I am not totally for not totally against the idea of letting users manage their desktops. I think there should be a standard configuration at setup, with any and...

Andy,

Thanks, it was nice to have found something to interesting to write about and then to have it published.

Just a couple of notes on things I thought about after submitting the article:

1. The title could have been better. It's really handling or logging data errors in...

Sorry I did not notice that you said SQL Server 2000 since the post is in a 2005 forum until after I posted and Gail had commented.

You want to use the Row_Number() function.

Select

cityName,

Row_number() Over(order by city)

From

CityMaster

I'll second what GSquared has said. The cursor is definitely slowing you down. Also the fact that you are doing 3 different actions based on the cursor means...

What is it you are trying to accomplish? When you say it failed, are you getting an error or just results different from what you expect?

Attached is a screenshot of a working filter on my report.

What is the exact error you are getting? I have basically copied and pasted your code into an existing report and run it without issue.

I have not tested it or really researched it, but odds are the trigger is firing using the ownership chain so you are getting DBO. LoginName in profiler is...