Probably SAN replication.

We just do a Windows Cluster (I say "we"... I mean our infrastructure group).  It's worked well for us over the last decade and has advantages over things...

Thank you for replying.

@Jeffrey Williams -

So the datetime data in transactional DB system is always stored in UTC. This datetime data is then converted in whatever timezone the...

I wasn't actually the one who pushed the SSIS packages to this particular server. I'm not sure if it was just imported straight from 2012 to 2019 or...

Just identifying the table here doesn't help - there are columns in the select and where the table isn't identified.  Use table aliases - and use the table alias when...

Despite the above reply, if anyone has ever seen this behavior before or has any ideas (aside from telling me to change how I run the package), please...

There is one duplicate - location_id = 19...my guess is there are multiple projects,...

I am curious - why do you need to convert the data in SSIS?  What is the format of the data - and what is the desired result?  Depending on...

Did you upgrade the package in Visual Studio?  How did you move the package from one instance to the other - was it done through VS?

If this is really stored...

The first problem is your files - since Excel has a limitation of 1 million rows, opening any of those files that exceed that number of rows in Excel just...

This is a bug in SSMS - and has been around forever.  The value that you see is 2097152 MB - which is 2048 GB - which is 2 TB...and...

Barring the questions @JeffModen has - why not just grant execute to the local service account one time and be done?

GRANT EXECUTE ON schema::xyz TO [localSQLAccount];

Any new procedures created -...

That's just it... I'm not. 😀  I...

True dat!  Things like a Cmd Task, etc, work fine... well, kind of.  With the understanding that I've not recently spent much time (I'm thinking precisely zero in the...

Not sure you can audit for that - I...