Probably not the operating system.  Have you checked the files in the two different places for things like...

1. Are the both using the same thing when it comes to Unicode...

Did you click on the text 'Failed"?  That should explain what is wrong.

If I had to guess - you have a 64-bit version of SQL Server installed and are...

The result of the query SELECT @@VERSION is:  "Microsoft SQL Server 2014 -  12.0.2269.0 (X64)"

I don't understand that (X64) because this query is executed in: C:\Program Files (x86)\Microsoft SQL...

@jeff

Had a strange error processing file from server...

It was the first file that had data...

StartDT: 15 Jul 2021 08:44:42:777 Working on file 25 of 89 files: G:\line_speed\F303-Line10.csv... Msg 2627,...

On the subject of "sometimes" quoted CSV's...

I totally agree that it shouldn't be necessary.  MS has had more that 2 decades to make this "simple" stuff right as...

 FROM tblRecievedQuantity TRQLEFT JOIN tblOrderQuantity AS TOQ ON TOQ.order_id = TRQ.order_idLEFT JOIN tblIssuedQuantity AS TIQ ON TOQ.order_id = TIQ.order_idLEFT JOIN tblReceivedTrack AS TRT ON TOQ.order_id...

Actually, both OR and ISNULL are horrible for performance and should be avoided... when I say "should be avoided", I'm very close to saying "must be avoided at all costs"...

My previous experience with SSIS was to determine a method to make table-to-table transfers like this work much more quickly.  The way I did that was I stopped using SSIS...

Now that you have a couple of answers, I have to ask... why do you need to do this?  What will it be used for?  What business purpose does it...

You left out the name of the date column for the two tables you're talking about and you didn't include those names anywhere in the code.  With that in mind,...

A systems works with Windows Server 2012 R2 Standard On this system MS SQL-server 2014 (x86) Express version 12.0.2000.8 is installed. The service pack SP3 had to be installed....

I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.

If I understand your question correctly,...

On the subject of "sometimes" quoted CSV's...

I totally agree that it shouldn't be necessary.  MS has had more that 2 decades to make this "simple" stuff right as have a...

Let's peel one potato at a time.  The first stop is the last item in your code...

 (jh.ProdQty - jh.QtyCompleted > 0)

Do you see any problems with...

As strange as it may strike some, I've not even downloaded DBATools, yet.  I'm sure it's documented on the site one way or the other but, just to ask the...