Post reply

doubt on ssis

  • June 17, 2009 at 7:44 am

    #384787

    hi this is srikanth ,i am new to ssis

    i got one doubt in ssis

    i want to trasfer tha date using sort transfermation from oracle to sql sever,i take sourse oracle emp table,fealds empno,ename,deptno

    empno ename deptno

    101 smith 10

    102 miller 20

    103 sree 30

    then i took target was sql server ,the table was emp_details,fealds are same,its already contain some data like below

    empno ename deptno

    101 raju 10

    102 rajesh 20

    what my question is ,if i transfer the data from oralce to sql server

    the data should be update like this

    empno ename deptno

    101 smith 10

    102 miller 20

    103 sree 30

    note :the target table in sql server will not allow duplicates,it should be update only

    plz send me answer as soon as posible

    thanks

    srikanth

  • June 23, 2009 at 1:03 pm

    #1014190

    plz send me the answer for above question

  • June 23, 2009 at 3:04 pm

    #1014283

    It would help if you let is know what you have tried so far to solve the task at hand and where you are having problems.

    We are all volunteers on this site providing assistance around our own paying jobs or on our own free time.

  • June 23, 2009 at 3:56 pm

    #1014321

    You need to use an SCD which can update the name record based on empno.

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

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