"...It is my opinion that the first syntax is best avoided, as I think it is not absolutely clear what the target is..."

How is "update dbo.tablename" unclear ?

I think the...

• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.

How big are the DBs ? Do you need to subset all the tables, or just a few big ones ? Do they have referential integrity to complicate subsetting ? ...

• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.
• This reply was modified 3 years, 9 months ago by homebrew01.

Chant:   "Mo-den ...Mo-den...Mo-den !!!"

This means that SQL  thinks your target field is not large enough for the data being imported.

"...The value could not be converted because of a potential loss of data...."

Also,...

And remember to put in some clearly written comments so the next person looking at the code understands what's happening.

Copy-paste from your spreadsheet into "Insert/Edit Code Sample"

• This reply was modified 3 years, 9 months ago by homebrew01.

Unlike MS SQL which has universally used SQL Management Studio, MySQL has various choices of tools to interface with MySQL.

I ended up using 2 different ones because they had different...

There are a few 3rd party "add-ins" products for SFTP.

We bought one at my last place. Don't remember the name, but it required annual support fee.

• This reply was modified 3 years, 9 months ago by homebrew01.

If your CSV has the same name every time, you can push it to a specific folder and run your saved SSIS package based on Ant's first reply. Or rename...

That's what I do on my SQL Express server.

First step is a batch file to delete backups older than X days

forfiles.exe /p "C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SQL_PROD" /s...

• This reply was modified 3 years, 9 months ago by homebrew01.

Was the system less busy when you ran it as Sysadmin ?

Are you getting consistent results with multiple tests ?

I use the GUI to generate a script, then I can modify and save it as a record of what was done.

Sounds like things I would have used Trace Files for. But I hear Extended Events have more functionality. I don't have much need for either these days. so can't help...

I wish I only wasted 3 hours on a current data upload project.

Perhaps the logs backups are configured, but not running.