Thx for the heads up. I'll probably stick with my existing method of importing the data, unless I get some real verification that the linked server has any significant advantages.
No I have hit a different problem although related to the above. If I have an FTP step in my SSIS package it fails under the Server agent, although if...
Thx for the info, but solved the issue. The sql server agent was running under its own credentials, and I had ceated the package under my credentials which have higher...