Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markymark35
Starting Member
3 Posts |
 Posted - 2008-07-17 : 15:58:33
|
| Hi,I have a linked server, i need to use it in an SSIS to manupilate and transfer the info to the sql server where the SSIS is locatted and it is executed from the same server.If i try this query in the server manager, it worksSELECT * FROM OPENQUERY(LinkSvr, 'SELECT * FROM Report.dbo.imp_Type')now, if i set this in an Execute SQL Task and hit F5 to run the SSIS, i get this error:Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "SELECT * FROM OPENQUERY(LinkSvr, 'SELECT * FROM Report.dbo.imp_Type')" failed with the following error: "Could not find server 'LinkSvr' in sys.servers. If i execute "SELECT * FROM sys.servers" in a query page or if i change the query in the SSIS, the linked server's name is in the result.Anyone has an idea? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 16:28:08
|
| What security settings exist in linked server? Does that login exist in other server? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:22:26
|
| It's not login issue. What's data source in ssis package? Connect to sql server that has linked server created? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-18 : 07:43:16
|
| Could it be looking for a link back from the server at the other end, and not finding it? |
|
|
|
markymark35
Starting Member
3 Posts |
Posted - 2008-07-18 : 08:09:38
|
quote:
What's data source in ssis package? Connect to sql server that has linked server created?
The SSIS is executed on the server where the linked server is configured. The data is to be retreived then saved to a table on another server. I do have a datasource set to the destination server that works perfectlly (if i run a select * command in a step to retreive the info from the destination server, i get a result).Does the SSIS needs a datasource to itself to use the linked server even if it is running on that server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-19 : 00:32:25
|
| I believe that's the problem, linked server doesn't exist in data source. You can try add linked server in that sql instance. |
|
|
|
|
|
|
|
|
Linked server in SSIS package