Post reply

Need a help in SSIS

  • September 6, 2012 at 1:52 am

    #393116

    Hi all,

    please explain me detaily.because i'm new to ssis, i dont know the options clearly.

    I declared one variable called var_1=1.

    I have one oledb source, derived column transformation and one oledb destination(oracle).

    my question is i want to give number for each record using that variable. incrementing variable by one and assign that in derived column TRANSFORMATION .Is that possible?

    SOURCE TARGET

    ENAME EMPNO ENAME EMPNO SEQ_NUM

    SATHIYAN 4500 SATHIYAN 4500 1

    RAHUL 4501 RAHUL 4501 2

    RHYTHMK 4502 RHYTHMK 4502 3

    Thanks and Regards

    Sathiyan.R

  • September 6, 2012 at 2:26 am

    #1534296

    If your source is SQL Server, you can just add the ROWNUMBER() function to your query.

    If you really want to use the variable, you need a script component, not a derived column:

    31 Days of SSIS – Generating Row Numbers

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 6, 2012 at 7:46 am

    #1534464

    Use script component and increment the variable proportional to the rows..

    Thanks,

    Arun

  • September 6, 2012 at 11:09 am

    #1534647

    thanks to all,

    i think for script component need to know .net coding.am i right?

  • September 6, 2012 at 2:05 pm

    #1534743

    sathiyan00 (9/6/2012)

    thanks to all,

    i think for script component need to know .net coding.am i right?

    Yes, but the article I linked contains pretty much all the code, so you'll survive 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 7, 2012 at 12:53 am

    #1534887

    hi koen verbeeck,

    that link is good.do u know any other link for ssrs and ssas(cubes).

    Thanks and Regards

    Sathiyan.R

  • September 7, 2012 at 1:01 am

    #1534889

    Can you be a bit more specific?

    Also, I'm not your personal Google. Most of this stuff can easily be found by browsing Google/Bing a bit.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 7 posts - 1 through 6 (of 6 total)

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