using a hex editor see what is the true row delimiter.

\r\n is one, but it can also be \r or \n on their own. (you can also try each one...

there is a trick.

create a temp table #dummy - 1 column with the same datatype/size of one of the tables used on your main select.

create a clustered columnstore index on...

create a view over that table without the identity column - then insert into the view instead of the table and see if result is what you wish for.

Ken solution...

what Ant said - while you can go with multiple vm's with small footprint those will also reduce IOPS considerably - so a higher vm (Azure constrained cpu for example...

there is something you can try which makes a HUGE difference on such transfers.

don't transfer directly to the final table - transfer to a staging table (#temp or just normal...

• This reply was modified 3 months, 2 weeks ago by frederico_fonseca.

well. taking in consideration the OP mentioned that this is a tab delimited file, and is complaining about CR on middle of a text, then what I said applies -...

it is a sign that your process likely should be changed as you said - high volumes like this are in most cases best dealt by pushing the lookup data...

ensure the file is a correctly built CSV file - if it is then you can load it using the format=CSV above - if it not then get whoever generates...

if the file is a valid CSV file, then use the FORMAT=CSV and it will load that record correctly - example you have above is not using the format keyword...

I'm going to repeat what I said above.

using SSIS (or any other tool that deals with correctly built CSV files) having a cr, lf or field delimiter within the contents...

if the file is a proper CSV file with the each column value enclosed in double quotes (and inside double quotes proper escaped) then you just need to define the...

the OP sql does NOT have a where clause - its only...

https://www.sqlservercentral.com/forums/topic/sustainable-procurement-best-practices-for-esg-driven-supply-chains-4  looks like AI generated with the sole purpose of being an advertising post of the "Zycus " software/company - and those commenting on it look just like bots created...

Express is free, but no SSIS/SSRS with this. I don't think there are free replacements for them

I might aim for a VM in the cloud I can shut down....

import wizard is 32 bit if you execute immediately - if you schedule to run on server it will execute the package on the server in 64bit mode by default.

VS...