Lynn,

Thanks for your reply.

I am executing through the Execute SQL object:

Exec usp_SLIM_Site_PreProcess

Very simple code!

it runs fine outside BIDS!

THanks for the answer, but it runs fine if outside SSIS!

Try to use SYNONYM

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/41313809-e970-449c-bc35-85da2ef96e48.htm

Great tip! AAAA++++

Thanks!

Make sure your destination table DOES NOT have any indexes