Hi,

we had similar problem..

From Query Analyser -window a simple "SELECT * FROM server2.dbName.dbo.tableName"

worked OK.. It returned a result set because in Linked Server Security -tab

"Be made using the login's current...

Hi Matt,

did you find any solution to FTP task problem??

We are now having exactly similar problems.. We are using SSIS FTP Task to get files from

ftp -server and sometimes the...