What do you mean "this type of files"? Do you mean that the files are a different type to the previous files? Are they .xls instead of .xlsx?

If...

According to the documentation, sp_who (Transact-SQL) - Permissions (yes, i realise that's sp_who, not sp_who2, but they need the same), you only need VIEW SERVER STATE. If you...

If you want to use SSIS, you need a consistent dataset. If you can't do that, it's going to be a real fight to try and get it to work....

What is your question here exactly? This looks a lot like a homework assignment; not something that the users here will be happy to simply give you an answer for....

Will the Primary Key be the column ID on every table? Also, I assume, you'll want to follow up with Foreign Keys afterwards; not sure you're going to be able...

I not going to bother anymore. I was happy to debate this (I enjoy debating things like this, as several parties can learn), but this isn't one. You're only happy...