Heh... in fact, we could make the system figure out what's wrong with a file, produce an errata list in an email and send it the client along with the...

Discounting the Excel thing for now, a little work in T-SQL will allow you to read the row header from each file, figure what's there, and assign it to the...

The table is missing the 6th column.  So is...

Yep. AdventureWorks in all it's messed up glory. Honestly, I love that sample database. Why? Because it looks like all the other messed up constructs I see everywhere else....

That's OK.  It's the tool that will allow you to do things like run the CLI of a program from SQL Server.  Such a thing can also be done using...

Awesome.  Thank you for the feedback!

I doubt it.  The still haven't made a built in sequence generator even though I've added to Erland Sommarskogs "Connection" post that he created more than a decade ago (going...

Perfect.  The next question is, which is a showstopper for a whole lot of people (even though it...

I saw that and was totally impressed.  It only took them 5 years to get a fix out... kind of.  As you say, it's only in Azure so far. 😀

Once...

Here is the plan:

-log into SFTP server and download files to local directory

-unzip files to specified folder

-import files into SQL Server table (it will always be the same table)

-if...

type = 'U' means you are grabbing all "user" type of login.  To SQL, a "human" and a "non-human" are identical.  It is just a login.

How would SQL know...

You're posting in an SQL Server 2019 forum.  BULK INSERT and BCP have both had "CSV" capabilities since SQL Server 2017.  If the files and the tables are consistent, there's...

Thank you everyone.  I have been saving the files to a folder.  it works for me because I only have a few queries. I am so used...

I don't feel comfortable flying normally but with Covid--even though I just got my booster and wear a mask everywhere--the thought of being on a crowded plane. ....

Thank you everyone.  I have been saving the files to a folder.  it works for me because I only have a few queries. I am so used to Access...