Accessing Linked Server through Shared Server in SSIS
===

I have a database conenction manager set up to server x. On Server x I have a linked server set up , y .

I run this query on the server x , it works 

  select * from 
[Serverx].[database1].[dbo].[Table1] A
left join [Servery].[database2].[dbo].[Table2] B
on A.[DNum]=B.[DNum]

I put it in a execute sql task in my SSIS package sitting on my pc not server x. Run it and it gives the error ...

Error at Task 10 h - 
Check for missing Deals [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR.  
An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available.  
Source: "Microsoft SQL Server Native Client 10.0"  
Hresult: 0x80040E14  Description: "The OLE DB provider "SQLNCLI10" for linked server 
"Server_Y" does not contain the table 
""database2"."dbo"."Table2"". 
The table either does not exist or the current user does not have permissions on that table.".

Query works on Server x, but not my pc using remote database connection to database on Server or usign execute sql task in SSIS .


Am I missing something ? Help please ?


