I'd probably use a Script Component (source) to do this. It will perform all of the parsing and output redirection for you.

The above advice would also work (except for the...

What is the format of the value in the CSV file? (Use a text editor, like Notepad++, to check this. Do not use Excel.)

From the ROWVERSION help:

Each database has a counter that is incremented for each insert or update operation that is performed on a table that contains a rowversion column within the database. This...

No problem.

Are there any deletes happening in the remote table?

Your suggested code looks fine to me. You could simplify it a little:

SELECT @LatestChange = MAX(VerCol) from localtable

I...

Presumably you Googled the error & found a load of posts relating to TLS config? What have you tried?

I've never tried, but do you have the password used when the SSISDB database was created? If you do, you could try the sort of stuff which is detailed

thanks for the reply.

It is really simple isolated table, just for testing

PriKey INT, VerCol rowversion, FieldB varchar(50)

I have now also copied this to another box that does not get...

The documentation seems clear on this:

Modifies the contents of an XML document. Use this method to modify the content of an xml type variable or column. This method takes an XML...

Fixing your PoSh script is probably a good way to proceed.

Because I have one product whose code is common for all projects which come to us, so we have to keep one database for one project.

and now we want...

There are lots of sites showing the holidays (here, for example). Are you looking for something special?

Phil, yes my ERP has the PK/FK information but D365 generates new ones when creating its records (my ones get saved into a separate field for reference). I think...

Presumably your ERP already has the relevant PK/FK information in it, so why can't you just use that? Or are you generating new keys as part of the migration?