issue

i have a data source which is a weblogs in which data is stored in ncsa format using ssis i need to get that data to one of my database tables

can u guys plz help me out in this.

i.e to to build the ssis scenario

thanks

praneeth

sample weblog

10.196.2.236 - wromero@.kpmg.com [26/Jun/2007:12:04:44 -0400] "POST /krisk3/krisk3/(ea12r4f4nin0ta55h0suj445)/Evaluation/Evaluation.aspx HTTP/1.0" 200 42925

You could use a script source to read the file in line by line and parse it into columns. Are the lines formatted consistently?

|||

I would be inclined to import the whole lot into a single-column dataset and then parse it using derived column steps.

This would work fine if your line length is relatively predictable (by which I mean you have no long text blocks in the entries) and you have a consistant end-of-line (no CR/LF in the middle of a line.)

If your data is more complex, take a look at using a script step to parse each line.

|||

Check the Fixed Width text file option. You can retrieve the columns as required. You can even pictorially see the reperesentaion in SSIS of your data.

Virendra