https://www.microsoft.com/en-GB/evalcenter/evaluate-sql-server-2016

This is a simp,e description opf the steps you need to do; as I don't have a lot of detail to go on.

OK, I would firstly create a...

To confirm, are you saying you therefore need to create 4 files (as there 200,000 rows)? I assume this needs to scale out as well?

Duplicate of https://www.sqlservercentral.com/Forums/1970852/SSIS-How-to-load-a-data-from-a-table-to-a-file-into-50-000-batches-50-000-rows-at-a-time. Please direct answers to the other topic.

The easiest way to find this out is to test:

USE Sandbox;
GO

BEGIN TRANSACTION CreateTable;

    CREATE TABLE dbo.test (ID int);
 

Ok, I just saw another post they just made, which i'm part quoting...

Saying "make a duplicate copy" in SQL or RDBMS is like saying "let's eat fried babies!" To...

I'm not going to link (but I'm sure many of you will guess who), and I'm not going to respond to them, but a certain very well known someone just...

What do the details in the system event log say?

I had to do something about some parts of that query, it was driving my "OCD" up the fall. The aliasing is one of my biggest pet peeves, and when...

I'vlm afraid I don't understand what you mean here by that you have 1 column separated by columns. Can you try to explain what you mean in more detail?