My personal feeling is that if you actually need a 3rd party tool to discover server instances, applications, and licenses, then you have too many unqualified cooks in the kitchen...

Don't do it.  Don't split date from time and put them in separate columns.  It will cause you more problems than you can shake a stick at.  If you absolutely...

Getting back to the original question, it's a extremely rare thing when I'll load external data directly to a final table.  With those extremely rare exceptions, I almost always load...

Heh... if the code is written properly, you won't need to use the likes of "Resource Governor" especially if there are only 50 million rows per month that are of...

Did that work for you or what???

You don't need SSIS for this.  You need proper constraints on your table and that includes if you're using SSIS.  The constraints will cause BULK INSERT to fail and sequester...

Google is your friend... here's just one link on the subject.,
https://sqlstudies.com/2015/11/12/hiding-one-or-more-columns/

The real key may be to ask the question, why does the user have access to...

Thank you.  It just needs to get started.  The boss...