Do you have any requirement for the availability of the data while it is being moved?  I believe the data would be unavailable while being moved from the faster SSD...

I guess I'd import the data that's not in the database, and depending on how they need to "match", I'd use an INNER JOIN between the 2 tables if only...

I think the problem with using the statistics is that a range (represented by a row in DBCC SHOW STATISTICS or sys.DM_DB_STATS_HISTOGRAM) can easily cross letter boundaries.  I did some...

that is probably just the most recent query that the blocking SPID ran, it may still be holding locks from a previous INSERT, UPDATE, or DELETE.  You can query sys.dm_tran_locks...

Yes, it's quite possible for this to happen, especially for a data error in the source. 
There is a way to control the records per transaction, fFor example, in...

A workaround I've used for the situation Lowell describes is to create the file in a "working" folder, then once done, move it to a "ready" folder.

On the...

I think we would need more information to figure this out, consider the following:
1.  "One customer can only create one account identified by the customer’s email address"
-  A...

I've used version control with SSIS packages for many years and never had a problem.  There hasn't been too many times I had to go back to a previous version,...