Use a Lookup Transformation or a Merge Join (data will need to be sorted), if you can provide more information I can have a look for you.

Can you write the start and end of the load to another table?

You can capture the LSN values manually but my concern is that you may miss data...

Hopefully this will give you more insight, when you import data in to SSIS, it will the data type to a relevant type in SSIS, this is done by sampling...

Yes it was exactly the same issue, after I slept on it, I realised what the problem could be, are you having any difficulty connecting to the Server Core installation?...

Yes using group policy, I will give the force command a try, I think you're right that this could be causing the issue because when I initially set up it...

It's part of a training exercise in the material for 70-462 - Administering SQL Server 2012, I know it's an old version but I don't imagine the installation on more...

I have read through the link but there isn't any error handling and it's not specifically targeted at Hyper-V environment or installing from an iso image so I'm still at...

Windows Server 2008 R2 Enterprise (Server Core Installation)