To the OP: why did you cross-post? You have enough points to know better. Do you realise that this annoys those people who take the time to answer in one...

You'll need to create two AD groups, one for standard users, who should not see the sensitive columns, and one for privileged users, who can.

Drop the 'all logins' group...

Your BEGIN ... END surround a single statement and should therefore not be required, unless you put them there for clarity.

Nearly! More like this, I think:

INSERT a2wh.dbo.CallLogCommon_dbc
(
    CALL_ID
   ,DATE
   ,TIME
   ,lead_id
   ,DOMAIN
   ,SESSION_ID
 ...

Yes indeed, that should work.

OK, I can't think of any reasonable way of doing that! I'll leave it for others to chip in.

They say that they still need to use the domain logon as everyone needs access but want to secure the sensitive information on certain tables but still be accessible...

I've never tried this, but if you use the (oxymoronically named) ACE driver to read the text file, using a connection string like this:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<filepath here>;Extended Properties="TEXT;HDR=YES;IMEX=1";

after...

Some background information from you would help illuminate the problem, I think.

So far, it seems that you periodically receive one-off files which contains hundreds of columns, which you would like...

As you are familiar with SSIS, you will probably know that you can redirect errors to an error table.

If your target staging table is set up with all of the...

What action do you wish to take if validation fails (eg, invalid date) for a particular row?

To fix the issue with not being able to edit scripts - you need to repair 'Microsoft Visual Studio Tools for Applications YYYY'.  This happens almost every time you...

Not sure about stopping it, but looks easy enough to handle in the proc, based on the differing lengths of the incoming string.

Aha, you're using Polybase. I thought you were using 'external' to mean 'somewhere not on this database/instance'!

I have not used it and therefore can't help, sorry.

I have no link for VS Pro, you need to buy it or create a VS subscription.

Before you do that, can you try creating a brand new package and adding...