Post reply

need help

  • July 21, 2008 at 3:45 pm

    #130166

    hello to everyone

    i need help very urgently from some one today becoz i dont have a clue how to solve this below problem.

    let me explain the whole scenario

    I have an oracle database which is my source database. There are certain tables in it. Then i have a destination database which is ofcourse the Sql Server 2005.

    There is a table in the oracle database called application table containing fields such as appid, appversion id,app name.

    Now for each appid there can be multiple versions such as

    appid appversion

    1 1

    1 2

    1 3

    1 4

    etc.

    Now there is a table in the sql server called the form

    which has the fields such as formid, Parent form id ,formName. the Table is empty and formid is the primary key

    Now there is another table in SS called pkid which contains the initial primary key value for the form table which is 200.

    Now what i want to do is when i import the data from oracle to SS the first time the value of the Parent formid will remain null and the form id becomes 200. when the second entry is made through importing then if the appid is the same in the oracle and the version is changed then the SS transfers the Previous form id value 200 in the parent id and make the formid value 201 and the same. But if the appid in the oracle change then the SS make the Parent id value null again and put the form1id to the new value of the previous value such as 202. what should be the procedure of doing that

    Please help i am in lot of trouble

    thanks in advance

  • July 23, 2008 at 6:31 am

    #846966

    Use Script component as transformation to place the logic you are looking for.

  • July 23, 2008 at 12:45 pm

    #847304

    can u help me in giving me the logic in steps of how to perform this task using script component

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

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