0

I am trying to run a query for multiple servers, but it is not inserting the results into the destination table from a different server. By debugging the Script from script component I got the error: Invalid Object Name: 'the table I am using to insert the results'. It works when running the query for the server where the destination table is, but not when running on a different server. In OLE DB Destination, I select the name of the destination table from drop list and it brings the schema next to the name; so the table is found. Am I missing something?

I only tried using OLE DB Destination. Is is correct or should I use another component?

Improve this question
2
  • Please show code and a repeatable examle: stackoverflow.com/help/minimal-reproducible-example Commented Jul 5, 2024 at 12:58
  • I just found the error; inside the query that is running on different servers is used destination table for left join without the server in the name. Thank you for your support! Commented Jul 5, 2024 at 13:32
Related questions
1
SSIS: Extract the target table of an OLE DB Destination object
1
SSIS Remove quotation from insert script to ADO NET Destination
0
SSIS Script Component for multiple column data
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.