I followed the example in the blog http://blog.hoegaerden.be/2011/04/07/loading-xml-using-ssis/

but no matter what I try the output only lists the values in the first column and will not display any...

ok I searched other forums and found a work around for How to tell the Execute Process Task not to open the Security Warning dialog :

I haven't got as far as running it as an sql job yet . This is still being debugged in BIDS. It runs with full admin rights.

I have...

Ahhhh after running this successfully for a month from 14/08/2008 I discovered a blip when the day changes from 9 th to the 10th (Discovered this...

Thanks this worked brilliantly for me . It has saved me much time and I now understand a bit more about vbs. 🙂

I have put this script into the last...

Thanks for that.

Dare I ask How?

I have tried using DTS to run the script and then open the Application but I am obviously missing a crucial stage here as...

Ahhh! well I am dissapointed.

So there is no way too restrict users using QA or BIDS while allowing them full access to their other databases via ?

Whoooo hooo!! found an answer meself......

I searched on this msdn forum

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=129105&SiteID=1

and discovered that the Surface Area Configuration Manager? Remote connections are disabled by default. ...

Oh I am an idiot      

I was using both fields in the dataset & controls in the report.

Consequently...

I am truly grateful for all your help and now feel guilty that I have been trying to solve the wrong issue

The Compliance  field is a calculated field which adds the...

Bracket "everything" does not work either.

I have just noticed that the other nested IIf

= IIF((Fields!Hazard.Value >=0 AND Fields!Hazard.Value <=19 AND(Fields!Complience.Value<41)),"Sat1"

Thanks guys,  but unfortunatly neither removing all the extra parentheses  nor  just using them around the Hazard value checks  make it work.