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?

You obviously need to create a job to run the package before trying that idea ... it should work.

I think I know what you've done. Your destination cannot have more than one input.

You need to delete the mapping from source to destination. Then add source to derived column...

If you can use CSV...

It's simple to do this - add a Derived Column transformation with one new column and set its value to "X".

Now map this new column to your destination column as...