I don't understand you're question. What are you trying to do here exactly? Could you please elaborate.

Thanks.

At work, the answer is no. We're a heavy Windows environment, so integration would be a lot harder than using Windows. We're also heavy users of both SSIS and SSRS;...

When you say you want to get it into the database what do you mean? SQL Server has an xml datatype, so do you mean simply store the xml in...

How about...

USE Sandbox;
GO
/*
All odd alignment issues courtesy of SSC's text editor 🙂
*/

CREATE TABLE SampleTable (ID int IDENTITY(1,1),
         StartDay varchar(9),
        ...

Out of the box, no, not really. You might be able to find something in the default trace, however, the only way to guarantee this is to set something out...

Thismmight even be something that can be done with project Variables as well, as opposed to environments. It depends if you have your dev and production database on the same...

It honestly surprises me how many people still leave themselves open to SQL injection. Parametrisation and the use of QUOTENAME (in SQL Server) make a query infinitely easier...

You can't really customise the look of SSMS, no, you just have the 3 theme options, Light, Blue and Dark (which is a hidden theme).

The following code doesn't make sense:
@[user::input file folder] + @[user::File Name] = \\ABC105.SSN.MERIT.PHILIPS.COM\VIPP_HT_Bckup_28-12\Actual load\2018\Mar_2018attachment_1
Firstly, you're trying to assign the value to 2 different variables which...

Just noticed something in the post. ISNULL isn't the same as a CASE, that's COALESCE. ISNULL and COALESCE do operate different; especially when different data types are involved in the...