Hi,

Thanks all the response.
It was the third party company that have experienced performance issues with the Project Deployment Model.
But even so I would still rather use...

Many thanks for the response.

The executions plans are the same, but because it is across a linked server we cannot see the remote query cost.

I think I'll just go with...

Right problem solved... well a work around has been found!

Since the LinkEase ODBC driver is old technology we decided to also use old technology and created a package using sql...

I'm pretty sure its not a rogue record. When running on the client the rows imported (in batches of 2199) reach 13194 and then move to 15393... Its...

Hi there thanks for the reply.

Integration services is installed only on the server and is fully patched.

When I connect to Integration services(on server) through management Studio on the client and...