I got exactly the same error with SQL2008 SSIS, the package was build with one connection to Excel sheet. The SSIS package ran fine but when the package was inserted...

Thank you Ian,

I did not think about it.

Thank you David,

I do not want table A on server 2 to be replicated back to server 1.

If I did, I would have set up merge replication.

I believe you're right...

Often, hiring managers value candidates that resemble to them.

I ran into several hiring managers who were not very technical and they did not bring in technical experts to verify what...

Sometimes, it depends on where you execute the DTS package. From my experience, it's best to execute the DTS package on destination server where the write operation is performed. ...

Ronnie,

Yes, You can create a job that makes a backup file directly on your target server which is your colleague's server or computer, she/he can use that backup file to...