Strange indeed - thanks for posting back & well done.

Rather than your 'blank' "" - which is an empty string - your values may be coming in as NULL.

Try this (untested) instead:

IsNull([Column_1])? "0" : [Column_1]

You can always add in...

Finding a character in a string - use FINDSTRING.

Finding a carriage return - look for "\r".

Finding a new line - ""

Edit, that new line code should say

double quote backslash...

What is your data source?

Not sure about that 'bug', but why not simply move the processed files to another folder (/Archive, for example)? It's tidier and your problem will go away.

Please include a question or two in your post.

Does the SQL Agent service user have the requisite privileges to access the other servers?

Then there is a suggestion that the time increase gets worse as each package runs.

Can you swap, say, Master1 and Master3 to confirm this?

It would be useful to know...

It would be useful background if you would explain a bit about what the packages are doing - what is Master3 doing that the other 2 are not?

🙂 happens to us all.

Are the quotes appearing as text-field qualifiers? Or just noise in your file that you want to delete? Do you mean single or double quotes? I omitted to mention the...

Pipe-delimited files can generally be imported just fine with the flat-file source & if I were you I'd spend more time trying that method before wading into script. Presumably you...

It is common practice to move a file to an archive folder of some sort after processing it - perhaps adding 'processed date' to the file name in the process.

If...

A pleasure, well done for seeing it through.

Is Converted_My_VALUE always numeric, or is it sometimes NULL? Can you give an example of some of the data it contains when it is failing?