problem in Concatinating two tables using SSIS

Posted by ajay_rawat86-7465 under Sql Server on 6/1/2011 | Points: 10 | Views : 1025 | Status : [Member] | Replies : 3
Hello everyone,

I am new to SSIS.I m facing problem.
I have two same tables comming from two different server i have to merge & concat both the tables into single table using SSIS Toolbars.for more information i hav
attached a file also.

Please suggest me correct solution for this problem.

Thanks & Regards

Ajay Singh Rawat




Responses

Posted by: Vuyiswamb on: 7/4/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
I think you need create a Task for each server , when you call your first task , it will insert data in SQL and do the same thing for the other text in the another server. but this means you will have two connection objects.

Thank you for posting at Dotnetfunda
[Administrator]

ajay_rawat86-7465, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 7/4/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi

I would like to suggest as follows

1. Create one Stored Procedure....
- Inside the procedure, Just combine the both tables result into single(Access the other server object using LinkedServer)

2. Call the Stored procedure using "Execute SQL Task"

So, In this case, You just need only one connection(where the stored procedure exists)

Cheers
http://sqlserverbuddy.blogspot.com

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

ajay_rawat86-7465, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rohithrs on: 7/4/2011 [Member] Starter | Points: 25

Up
0
Down
use merge transformations to merge two different db server table data into single

ajay_rawat86-7465, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response