Can you clarify what you mean by 'correct order'?

If possible, some sample data would probably help ... just enough to illuminate your ordering problem.

Yeah - I reckon you'll get more than just the table name by doing that. If you try 'object', does the error go away?

You might need a bit of script...

So it sounds like you want to be able to repeatedly (at defined periods) process an Access database. (Is there only one? Will it always have the same name?).

Every time...

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?