One thing I'll try to debug things like this is use a simple command and direct the output to a file. For example:

dir \\MAINDRIVE\subfolder$\dept_folder\Inbound > output.txt

There's nothing you can do from in your existing process if there are rows with a size > 8060. You need to truncate them before they load to ensure the...

I can create this table:

CREATE TABLE MyBigTable2
( myint INT,
  mychar CHAR(8000),
    mydate DATETIME,
  mychar2 VARCHAR(8000),
  mychar3 VARCHAR(8000)
)
GO

Not to press, but this is why we built SQL Clone at Redgate. It allows developers to get a full copy of data with minimal space/time issues.

Run your query without the sum, just get a field or two. Do you get data? I suspect that you haven't structured your query correctly, but if you don't provide...

A few choices I'd recommend:
SQL Skills - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine
Brent Ozar PLF - https://www.brentozar.com/training/
Steve Stedman - http://stevestedman.com/consulting/training-classes/
You can also look at...

Here's the BOL article: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine

We don't have a great article here, but we need one. I'll see if I can  get one up. The idea is...

You say import static data, does this include transactional data for tables that developers need? Or is it just lookup data?

Otherwise, this is fine, though I'd set this...

Arrgghhh, WRs didn't show up and despite a high score, apparently Mr. Ryan wasn't interested in his stats.

Grr.

I was actually owed beers, but I thought this would be a funnier scenario.

Fortunately in the real world, the tally was much closer to zero.

Cut/paste? :laugh:

I love Prompt, and every once in awhile I don't have it and my productivity goes down.

I've definitely  enjoyed  templates over the years, and...

We usually do this with joins.

select l.*
from lineitems l
  inner join  orders o
   on o.orderid = l.orderid
where customerid = @customerid

LOL, I can  understand that. The serverless stuff is interesting for some things. Not sure I'd use it for ETL either, but you certainly could just query/update things. Tracking how...