I'll have to guess at your question, as you have not stated one ...

Use something like

Right('0' + [month as Varchar], 2)

That is a fairly horrendous requirement 🙂

Unless you can put logic into the front-end application to track Field Last Modified, you just won't have that info. Same with 'Record Last...

You have a single table containing all that stuff? Sounds like it might be in need of some normalisation ...

Do you want to track the change dates separately for each...

isnull([likes_fish]) ? FALSE : [likes_fish]

should work.

You could add a derived column with an IsNull() check in it to force your source data to be compliant with your destination's requirements.

Wow, that's a big statement. I think the older...

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?