problem in Concatinating two tables using SSIS

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

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

0	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

Latest Posts