Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS package insertion statement Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 8:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 26, 2013 3:52 PM
Points: 42, Visits: 115
Hi Guys,

How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem

1. We are having 2 different servers like (LNEW8T8,LNEW3T3) same databases and tables format we wanted to check the LNEW8T8 database and table (usertble).

If usertble table data if user id is exist don't want to insert the data in LNEW3T3 other wise insert the data.

please share more effective way of achieving this solution.

Thanks
Ranganathan palanisamy
Post #1360532
Posted Monday, September 17, 2012 10:37 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:59 AM
Points: 562, Visits: 885
ranganathanmca (9/17/2012)
Hi Guys,

How to design SSIS Package for my below requirement please share some idea's and view to achieve this problem

1. We are having 2 different servers like (LNEW8T8,LNEW3T3) same databases and tables format we wanted to check the LNEW8T8 database and table (usertble).

If usertble table data if user id is exist don't want to insert the data in LNEW3T3 other wise insert the data.

please share more effective way of achieving this solution.

Thanks
Ranganathan palanisamy


Few queries here.

1. Why only SSIS ? You could have used linked server concept also.
2. What is the source of Userid i.e. are you checking with some file or again from some other database.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1360551
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse