I also tested this in Azure SQL Database. It's showing two different values as well.

However, I checked in my version of 2016 SP1, and it also showed two different values.

Not an SSIS expert by any means, but...

I assume you have a delimiter between the fields that translates to columns? If so, you should be able to map those out...

Probably the easiest way is to set up a scheduled check for the existence of the file. If it's there, fire off the load process. If it's not there, wait...

Everything everyone else has already said, plus, to help troubleshoot, you can look at sys.dm_os_wait_stats before and after running the restore to understand where the slow downs are occurring. You...

I'm going to try to work up a blog post on this over the next couple of days. If I get it done I'll come back here & post a...

It is. I don't have an example handy.

Since you're on SQL Server 2012, instead of using Profiler, I'd strongly recommend you use Extended Events. They have a much more lightweight footprint than Trace Events (you wouldn't want...

I use this list a lot (and usually Microsoft hovers around #3 or #4, occasionally #2). It's a great tool for discussing why...

We use Azure Automation. You can schedule it pretty much like Agent. Currently we don't have any specific maintenance for Data Warehouse because we do a daily reload. There's nothing...

All respect to the GUI, it's so much easier to backup and restore databases using T-SQL. Here's a good intro on the topic [/url]that ought to give you everything you...

I agree with Chris. If you can verify that all your databases are being backed up, then the issue is somehow within the job itself. It's not exiting cleanly. You'll...

Which the optimizer then turned into what I was writing:

SELECT Expr1002 = CASE

...

AZCopy is how I would do it if you aren't going to use the Redgate utility.

As to cost, the Redgate utility as currently configured, is free.

Sorry, I was away from email. However, the other answers are what you need to do. Get a list of successful backups (which was a part of Thomas' article) and...

Thomas' stuff looks excellent. I'd follow that method. If not, just querying the backupset system database can at least tell you what has been successfully backed up. You can then...