October 10, 2008 at 4:22 am
Hello,
I'm trying to get some bulletproof scenario for a fax application.
Therefore i should have the possibility to read out the information coming from MS Fax logging
Now i was trying to get a way regarding the use of Ms LogParser but it seems not possible to read in this file
So now im watching the possibility to get my results in a salserver kinda way.
The fields im intrested in are : billingcode (in witch we can place a id for a certain row) and the Status field
Still there seems to be something wrong with the logfile that blocks me to get it in a proper formatting.
Also there are a lot of empty fields.
Could someone advice me for the possibilities before i waste a week orso when it would not be possible in sqlserver way.
Tnx in advance
Eddy
October 10, 2008 at 9:14 am
It is possible to read in a tab-delimited file into SQL Server. However, your sample file seems to be missing end-of-line characters? If you can define an end-of-line marker or character, I think this should be doable via Integration Services in SQL Server 2005 (SSIS).
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply