The simple answer is YES. We can connect through link server and can access other tables while importing/exporting other tables.

Hi Eric,

Sorting/Joining would cause temdb grow. Even if you run using SSIS package, it will internally sort the data from cache memory set to SSIS.

Hope this helps!!

Thanks,

Sridhar.

Hi Dave,

Make sure you have all permission and check for the following resolutions.

Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection...

Do you just wanted to connect to all your Servers or perform any activity connecting to servers?

What is expected from forum readers Dave from your error log?