I'd enjoy it.  I know I have wanted to start speaking in general and plan on doing a presentation at my local chapter sometime soon.  But I have also been...

Do you have windows authentication turned on on the server?  If so, just add the windows group instead of the individual users.
Otherwise, you would want to create a SQL...

I agree with Lowell here.  I would export all of the dtsx's using powershell.  You should also get all the DTSX's (or ISPAC's) off of your server so you have...

Another thought - does your SSRS server have access to the Excel file?  If it is on a network share, are you using the full UNC filename or the drive...

Try it.  That is the best way to know for sure.  Inserting into a temp table (as long as your tempdb isn't full, which will cause other problems as well)...

Might not hurt to run chkdsk on the drive as well.  Could be the disk is starting to fail.

I could be wrong, but I think the problem is you are doing incorrect data type conversion.
You are dividing an int by an int which will produce an int....

No problem.  As for IT being repetitive, it depends on where you work as well.  Where I work, I was slowly building up a list of canned responses to people...

The best approach (from my understanding) is to not force reuse of old values.  The primary key, for best performance, should be an ever increasing value.

Why do you...

So 1/6 of your data has the longest MethodNames.  This is likely part of what is causing the slowness.
What is the max length of that column?

Also, what...

We have things set up that way where I work.

The only thing you need to be careful of is that SSIS operates in separate memory space than SQL...