This script below seems to be working but I am wondering if someone can help out a little bit. I will try to be as thorough as possible when asking...

We are still on SQL Server 2008. Not even R2

Thanks Sue. I actually found a script online and have been tweaking it but getting an error "Invalid Parameter" when I run it. I don't know what I am missing....

Silly me. I am not sure if some one can help me write a script? I am not sure where to start from.

Maybe a silly suggestion but can you set the DB offline and then run the restore or maybe change your script to kill active sessions?

ALTER DB [DBNAME] set...

I was thinking about creating a temp table (denormalize the data) which can be used to display the report but I am running into an issue and it has something...

So I just want to make sure that I understand that correctly, if we have a development version of SQL Server installed on the dev server where we have SSIS...

I had a feeling but wanted to confirm. Thanks guys.

That's what I am working on right now (copying the data)
Thanks!