Post reply

SSIS package insertion statement

  • September 17, 2012 at 8:35 pm

    #281488

    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

  • September 17, 2012 at 10:37 pm

    #1538890

    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

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
     🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply