SSIS SCENARIO

  • Hi,

    this is the scenario i am trying can anyone help on this(its urgent)

    204.243.130.5 - - [26/Feb/2001:15:34:52 -0600] "GET / HTTP/1.0" 200 8437 "http://metacrawler.com/crawler?general=dimensional+modeling" "Mozilla/4.5 [en] (Win98; I)"

    204.243.130.5 - - [26/Feb/2001:15:34:53 -0600] "GET /logo1.gif HTTP/1.0" 200 1900 "http://www.clickstreamconsulting.com/" "Mozilla/4.5 [en] (Win98; I)"

    204.243.130.5 - - [26/Feb/2001:15:35:26 -0600] "GET /articles.html HTTP/1.0" 200 7363 "http://www.clickstreamconsulting.com/" "Mozilla/4.5 [en] (Win98; I)"

    The information we have in the above said records are as follows

    h: The remote requestor IP

    i: the remote server name via identification (typically -)

    u: authenticated user unless required (typically -)

    t: time in GMT

    r: the entire text of http request

    s: the returned http status code

    b: no of bytes in the returned page

    i: most recent referring URL

    a:the requesting software type (usually browser type)

    Create a ETL package which takes the input as above mentioned file and generate an output as follows.

    Ouput should be

    204.243.130.5,,,26/Feb/2001:15:34:52 -0600,"GET / HTTP/1.0",200, 8437, "http://metacrawler.com/crawler?general=dimensional+modeling","Mozilla/4.5 [en] (Win98; I)"

    204.243.130.5,,,26/Feb/2001:15:34:53 -0600,"GET /logo1.gif HTTP/1.0", 200, 1900, "http://www.clickstreamconsulting.com/","Mozilla/4.5 [en] (Win98; I)"

    204.243.130.5,,,26/Feb/2001:15:35:26 -0600,"GET /articles.html HTTP/1.0", 200, 7363, "http://www.clickstreamconsulting.com/","Mozilla/4.5 [en] (Win98; I)"

  • What is the question here? Do you have a specific problem somewhere where you need assistance?

    Or do you just want someone to make the entire solution for you?

    ps: take a look at the derived column component

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

  • Hi,

    Actually in derived column i used the substring and Instring ,and i got the solution but the problem is in source there are 3 records.

    After running the ETL JOB i got only the single row in target...

    can u help on this....

  • maheshkrishnas (11/13/2011)


    Hi,

    Actually in derived column i used the substring and Instring ,and i got the solution but the problem is in source there are 3 records.

    After running the ETL JOB i got only the single row in target...

    can u help on this....

    What is your problem exactly? You have 3 rows in the source, but only 1 in the destination?

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

  • Hi,

    Actually the problem is My source & target is FLAT FILE. when i run the ETL it reading the 3 records in source as 1 record & sending that to Target

    But it should read all the 3 and send to target as 3 records.

    Example: Acv 2345.456 cbnvfr 200 5673

    Acv 2346.567 vbndfr 200 3456

    Acv 2347.567 dvbnfr 200 4216

    But it reading like this

    Acv 2345.456 cbnvfr 200 5673 Acv 2346.567 vbndfr 200 3456 Acv 2347.567 dvbnfr 200 4216

    Expected output is

    Acv, 2345.456,cbnvfr, 200, 5673

    Acv ,2346.567, vbndfr, 200 ,3456

    Acv ,2347.567, dvbnfr, 200, 4216

    this is the problem

  • What have you configured as the row delimiter in the flat file connection manager?

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

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

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