Perfect thanks. Now I see the propereties window I remember that I have forgotten this step with every version switch since SQL 2000 🙂

How do I replicate the above in an SSIS package?
In asp.net I just add some using statements for some nampespaces and I'm away but in a package I'm guessing...

It's a bit of both... I can get the results from the webservice and into a variable in a few lines of C# but the data manipulation and passing to...

Right finally got some time to get back to this.
As far as I can tell I have successfully built the dll and pout in the GAC on my local...

I tried 2 different providers to link the images, the current one being a shared OneDrive folder. No idea why they won't show, luckily the images don't add a great...

Thanks guys, this gives me what I need.

I sense you are testing whether I am posting a "homework question"... at 49 years old in 2 weeks, I should be so lucky 😉

OK...

Here is my query

SELECT SUM(Amount) AS...

I'm going to stick with the simplest option and this is to reconstruct the same table structure in the destination as in the source.

I recently had a similar challenge where...

I'm sure it is doable e.g. create a table data type which contains names and values and loop through the values trade=roofer, name=John

I'm just starting to think it may...