Sorry I am reasonably new to the forums. I saw the link http://www.sqlservercentral.com/Contributions/Edit/71571 and I couldnt access it.

However the link you just posted works great, thanks.

Neither links work...

great article! I never realised how simple it actually is to get XML out of 2005.

why not store the characters in spanish?

use nvarchar as your data type

Orderdate is not unique so you cant group with that there unless you want each customer order with the same count. You want to do something like this (here...

Im sure there are easier ways but try adding a Script task and use on of the IO File objects to check for the file then depending on the result...

Dont select multiple subscriptions when u delete you have to delete them one at a time.