Then it's a puzzle. You could try setting DelayValidation = True on the CM.

You could also check the All Executions report to look for any other clues. Does the error...

Sorry, I missed that.

Does your script task use the connection manager? Are you disposing it?

That's a very common error, so don't expect it to correlate well to whatever the problem is!

Are you trying to read anything in parallel, eg, two or more sheets in...

• This reply was modified 3 years, 2 months ago by Phil Parkin. Reason: Fix typo

In SSMS, that is not possible – it is seen as a query tool, not a presentation tool.

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.