yes it is the same thing...

that configuration manager reference there is to be executed on the SERVER where SQL Server is installed, not where you installed the client tools.

So unless you also intend in having...

or keeping the CTE change "and b.userID is null;" to "WHERE b.userID is null;"

I may be wrong - but installing POsh 5.1 should contain the automation namespace - and this will not be .net core

https://www.microsoft.com/en-us/download/details.aspx?id=54616

I think I have that working in one of my packages but through a start process e.g. new process kicked off which starts a new powershell instance.

if that works for...

order does not matter - and the way it works "logically" is that for each row on the out query (customer) check if a row exists on the inner query...

Have a look at Power BI Report Server - that is the one you need and it is a superset of normal RS server.

Assuming you have SQL Enterprise with...

first.... why in HELL will you have a production database dependent on details stored on a dev database?

second - what SQL Server license do you have on your Development database?...

have a look at https://dba.stackexchange.com/questions/246773/prevent-ssms-from-seeing-the-servers-file-system

but use at your own risk.

why do you need to hide this?

and check if on your 2012 server any permission was removed - either directly or...

what is the final purpose of this SQL - how is it going to be used and where is the final output? e.g. csv file, excel, web page?

I think you have issues understanding exactly what you need - a DATE field has no format.

you can convert a date to any format you want for writing to a...

don't do that on SSIS - do it on the select from the table where it will be a lot easier to do and will be faster than doing it...

do a query on the max and min values for r.ActualAllowed - that * 100.0 is most likely resulting on a bigger value than what a decimal can hold.

so casting...

unless you license your PC with a valid SQL Server Standard/Enterprise you can't do it for production purposes.

If you are not using those daily loads for production then you can...

we are in the process of deploying the packages to an integrated environment

What do you mean by that, as in deploying them to SSISDB? Are the packages all in...