I'm not sure what you are asking. What exactly do you want to be alphabetical? The case name which is 'test', the sequence number (5), or the case_cred...

Try checking for special characters like Tab and Carriage Return, they are not removed by the TRIM functions only blanks (spaces) are.

Well the implementation of your logic looks okay, but because I don't know all the in's and out's of the system I can't tell you if the logic itself it...

Ben,

I guess I also misread or misunderstood your post the first time through. I guess the issue I have is that I can get the error...

Yes, almost every transform component has an error output.

You must have a mkt_rate column in one of your tables that is being used in the function call because SQL will not let reference an alias name in the...

Check out this article, http://www.sqlservercentral.com/articles/Test+Data/61572/, and the discussion that goes with it as there are some other ideas in there as well.

Yes you can do what you are planning and pretty simply as long as all the character values CAN be converted to integer. I'd do it something like this:

Update...

I don't think adding indexes to the updated column or the column used for the update will help. In fact adding an index to the updated column will likely slow...

If you go through this thread I there is a post with a SSRS Report that displays the error data.

You are right that this does not tell you which...

Is the whole point to remove nulls? If so you need to change the columns so that they do not allow nulls. Finding nulls is easy:

Select

...

Apparently I am in a rare situation as I am more positive about the economy than others. While I don't know all the details, I still see help wanted...

Barry,

Yeah, the licensing confusion is almost enough to make you go to a LAMP architecture. I was already planning on calling MS since no one seems to really know....

The ErrorCode is part of the Input to the script component so you do not have to create it, it is already there as long as you have a synchronous...

Interesting. The xpsmtp page doesn't display correctly in Firefox 3.0.3. It is fine in IE 8 though. So you should

just go to the link Terry provides. This...