THat sounds like something to keep developing, sounds like a good solution.

Many Thanks!!!

any update?

THanks

I tried exposing the 2 fields in CTE then added your code after:

FROM MTD_INV_LINE_ITEM AS D

JOIN Ranked AS R

ON D.Invoice_Nbr = R.Invoice_Nbr

AND D.prime_line_nbr = R.prime_line_nbr

AND D.Mtl_Type = R.Mtl_Type

AND R.rk =...

The machine is the first part F300-line1  F300-LIne15

machine - 300

Line - 1

it could have up to 15 lines..

As far as the process used, as long as it's fast..

Many Thanks.

want to tackle the re-write sure could use some help..

Thanks.

This is what the failed file looked like:

"stamp_time","wirespeed"

"1/2/2019 5:53:45 PM","187"

"1/2/2019 5:54:18 PM","187"

"1/2/2019 5:54:51 PM","188"

"1/2/2019 5:55:23 PM","187"

"1/2/2019 5:55

When I was dumping data it caught it in the middle of a write...

does this process have to read the entire file before loading?  Is there a SQL solution without using SSIS?

Thanks.

I found the problem when data was extracted it was a point in time, and on one of the files the last record was partial written.

Is there any any to...

Doesn't seem to be working...

2021-06-02T12:03:27 Loading C:\Line_Dumps/*.csv into process.

2021-06-02T12:03:28 Loading F306-Line5.csv

2021-06-02T12:07:28 Load complete.

Exception calling "WriteToServer" with "1" argument(s): "The given value of type String from the data source cannot be

converted...

Sql version is 2012 and the files are named like

f300-line1

Powershell seemed like a easier solution to getting the filename into the table.

This is what the data looks like I'm trying to process. The first line is the header...

"stamp_time","wirespeed"

"3/25/2020 7:31:47 AM","226"

Thanks any changes to script to handle input?

For example, you use "mtl_addr_price" both as a column name and a table name.  Is that actually correct?

That's correct the column is coming from a different table, and there is...

I added in the Left join C1 section, but seems like that didn't work. I maybe misunderstanding where to insert new code.

Thanks!!

If there is a better more readable way of doing this update I would appreciate your help.

I'll try and add the code for left join of C1 and see what...

Yes sorry typo when I pasted.

and d.Prod_Line in ('xx87;)

Any help on how I and where I add the extra criteria?

Thanks.