Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sauce1979
Starting Member
47 Posts |
 Posted - 2010-03-08 : 10:17:10
|
| I am trying to create a fact table in our datawarehouse that will allow our analysts to determine the our essbase olap database usage. i.e. the numbers of logins per day,per region, specific cube usage.I am using the essbase log files to pick up the data. I would just like some direction on how to use DTS to read the log files into our Warehouse.The log fiels are in the following format:[Mon Jan 05 15:33:23 2009]Local/GMR09/OTLCHK/admin/Info(1013091)Received Command [OtlQueryMbrs] from user [admin][Mon Jan 05 15:33:23 2009]Local/GMR09/OTLCHK/admin/Info(1013091)Received Command [OtlQueryMbrs] from user [admin][Mon Jan 05 15:33:23 2009]Local/GMR09/OTLCHK/admin/Info(1013091)Received Command [OtlQueryMbrs] from user [admin]I want to disregard the lines that begin with Received It should split the other lines into:Day of week, Month, day of the mionth, time, year, APplication, Database,Userhence the first row should beMon,Jan, 5,15:33:23, 2009,GMR09,OTLCHK,adminAny help would be much appreciated. |
|
|
|
|
|
|
|
DTS TO READ LOG FILES