Thank you all for your insights!

I suspect that my colleague and I have reached a 'syntax impasse' on this one.

And whilst ordinarily I would agree SSCarpel Tunnel

- in this...

Sadly I have no idea what product evaluation took place

- because I was hired to support the BI/MI of things as a result of buying into said software.

HoHum -...

Hello,

I think this was the result of a bug in WinScp 4.2.8

which was resolved in version 4.2.9.

Hope that helps,

Helen

Hello,

Thank-you for the response.

The report looks fine via the web interface.

If I delete the subscription, recreate it and run the sproc it succeeds.

And the only differences I can find in...

Hello,

This works perfectly for me when run once - but won't "re-run".

Every subsequent attempt results in an report status of 'Root element is missing'.

I've checked the Subscriptions and ReportSchedule table...

Sorry Guys,

I didn't spot your replies before I responded!

I've checked and changed my Query Output Options and all is right with the world again.

Thank you all VERY much,

Helen

Hello again,

Your response inspired me with some new search strings to try in Google.

It is because I was sending my results to Text - so they got chopped at 1000...

Hello!

Both queries are in the Management Studio

Hello,

You could try using the Ascii Characters like this:

Select Payee, Replace(Payee,Char(39),Char(96))

From Payee

Where Charindex(Char(39),Payee) > 0

I usually do this to work out what the character codes should be:

Declare @Count int, @Limit...

Hello,

No I'm not using multiple values for this one but I do know what you mean.

I'd be interested in seeing how you resolve it if you find a way!

Helen

Eureka!!

I commented out the parameters and the data Previewed beautifully - the data is still rubbish but at least I can see my rubbish data!!!

I've since deleted and recreated the...