Suggest to do it on Non-Production environment first if you have.

I don't see if there is a value to do a check again as you already did when it written to the local disk.

Why not do your database backup directly...

If I understand correctly, you want to check the data integrity of a database backup file that was moved to a remote server, Is that correct?

It depends on how critical is your database.

There is an option: Enter the full absolute URL to the image to insert...

I don't think you can connect from SQL Server 7 to SQL Server 2008.

Check out, http://www.sqlservercentral.com/Forums/Topic1037190-1550-1.aspx

Do you have database backup? =)

What is your database status now?

Are you a recruiter?

Try posting on Data Warehousing » Integration Services

Example can be found on this blog, http://saveadba.blogspot.ca/2012/02/get-io-cpu-intensive-queries.html

This might help, http://support.microsoft.com/kb/2829783

I had done it in the past with similar requirements.

https://technet.microsoft.com/en-us/library/ff772782(v=sql.105).aspx

I suggest to re-download the Service Pack again.