As a thought... if you disable the writing to destination step of the SSIS package, do you get errors still?

I am wondering if MAYBE the problem is on the destination...

I am not 100% sure if IF statements would handle that better or not.  Been a while since I tried it.  Just tried it and it does not work.  So...

My bad... didn't see the attachment.  Sorry about that.

Looking through it now and will let you know if I see something to do what you need.

EDIT - your attached script...

• This reply was modified 5 years, 10 months ago by Mr. Brian Gale.
• This reply was modified 5 years, 10 months ago by Mr. Brian Gale.

Could it be a problem not with the valid dates, but with the NULLS?

As a quick test for that you could make 2 files, one that has a value in...

Just my 2 cents, but devs shouldn't be running queries against live, espeically if they are going to take down live by doing so.

What about if you break that out into IF statements instead?

Could you post some sample code?

My expectation is that you are going to need a case statement in there, but would like some sample data to work with and would...

Gotta love how Windows does that... different OS versions can have different font files even though they have the same name.

If you do try swapping fonts around, make sure to...

PDF working makes sense as that is rendered entirely server side.

Excel though should work too.  If you do find some bandwidth to investigate, my guess here is that the font...

could you not put a WHERE clause where your category description is not RTF TOTAL?

Don't think you can do that with a group by; I think it will need to...

If your two databases are on the same instance, and depending on server setup, you should be able to do that with a trigger.

If they are on different instances, a...

So, SSIS is a tool that would need to be installed on the server and you'd build things up for it.  Service broker is a series of scripts you would...

UNION will be your friend there as long as the tables have the same number of columns OR you can add fake data into the missing columns.

In your example, I'm...

Service broker could handle that.  Pop a trigger on each table that fires off an XML message to the backup database of what changed and a stored procedure on the...

Do you have those fonts installed on the server side?

The fonts need to exist on both client (for rendering the report and viewing online) and on the server (for generating...