tried that, but the install did not like just having the .msi file...error msgs that I received were somewhat cryptic, but I believe it was looking for other files as...

Could you please provide more detail ?...it needs to be part of a package and Im using a select query to pull out various fields out of Table A (not...

Your answer is consistent with what I discovered in my environment.

Thank you

SQL Bill, I receive the follwing messages when I perform your syntax;

File 'Customer_Primary_0' was only partially restored by a database or file restore. The entire file must be successfully restored...