April 22, 2014 at 8:30 am
I am new to SQL, I created a table on a destination database and I am trying to transfer data from a database on one server to the destination database. I have this in a script and included in the script is an insert and a join statement to the other database. The query looks something like this..
select id
from database A
where name = ABC
insert couple of values into the new table created on database B
from database A
inner join statement on database A
Can I incorporate all these statements and runs it in an SSIS package...
Any help will be appreciated
April 22, 2014 at 8:54 am
Yes, you can run your script in SSIS. Use an Execute SQL Task
April 22, 2014 at 9:02 am
The databases are on different servers... so I use the Execute SQL task it will not work
April 22, 2014 at 9:51 am
Use either Merge Join or Lookup transformation in the Data Flow.
😎
April 22, 2014 at 9:53 am
Can you please elaborate on how to use the merge join... Thank you
April 22, 2014 at 10:02 am
April 22, 2014 at 10:13 pm
The Simplest of all would be to create a link server between the two database servers and then execute the query using the linked servers.
Plz reply if you want to know how to use link servers.
🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply