Deleted.

Thanks Phil for the starter.

I was playing around with it this morning, and I produced this:
"BEGIN TRY
    BEGIN TRAN
        IF OBJECT_ID('dbo.[ce.rfi_yle_dm_v2_PreviousExecutionData]', 'U') IS NOT NULL
        DROP...

Ah I see. The environment I've been handed to use, which I do not have permissions to install software, is using VS2010  🙁  I have requested 2017 to be installed....

Hi Phil,

Does the below look correct if placed within an Execute SQL Task component?  Is the THROW used to set the 'FailParentOnFailure' to True, if so how do...

Thanks DimPerson and Phil Parkin for your responses.

Firstly, Phil - I'm not great with C# so do not know how to do that approach at present (I will...

Deleted.

Deleted.

Deleted.

Of course. Thanks for pointing it out. I guess it was a case of not seeing the wood for the trees.

Thank you so much for all your help with this.
I actually got there with the below. I just need to replace _ with / and the 192_... with the...

Thanks for your replies.
I'm at a basic level using SQL so forgive me for my novice questions.
The database I'll be pulling from is not mine. I only have...

It won't be detrimental as versions build on themselves. Sometimes the earlier versions explain things better since they spend more time on the stuff that was newer back then. Once...

Thanks for all your replies. Really appreciated.

I have installed the 2016 version of the SQL Server software (as stated in previous posts). I am having trouble finding training videos for...

When the term 'Power BI' is mentioned I think of a visualisation tool. A tool that can hook into various sources (flat files, websites, etc..) and then produce colourful visualisations...