What do you mean by "type of table"?

--Edit

are all of the physical tables already set up in SQL Server, or are you hoping to do some sort of create-then-import...

This works - just tested it:

RIGHT("0" + (DT_STR,4,1252)DATEPART("dd",GETDATE()),2)

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?