May 28, 2010 at 12:50 pm
SSIS package has connection to server A, server A has linked server to Server B
I can open connection to server A in management studio and run query with no problems but
when I try to do this same query through ssis package it fails with following error:
Error: 0x0 at Execute SQL Task: OLE DB provider "SQLNCLI" for linked server "Server B" returned message "Login timeout expired". I am sure it is related to the linked server but cannot find a solution. Any ideas?
May 28, 2010 at 1:05 pm
Jeff Self (5/28/2010)
SSIS package has connection to server A, server A has linked server to Server BI can open connection to server A in management studio and run query with no problems but
when I try to do this same query through ssis package it fails with following error:
Error: 0x0 at Execute SQL Task: OLE DB provider "SQLNCLI" for linked server "Server B" returned message "Login timeout expired". I am sure it is related to the linked server but cannot find a solution. Any ideas?
Is there a reason you can't create a direct connection to Server B and run the SQL query directly?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply