Hi this is log file in text format
Info: 2013-10-27 23:37:58.74
Code: 0x4004300B
Source: extract SM ticket xref SSIS.Pipeline ####!! the
text between Source : and SSIS.Pipeline
>
Description: "component "OLE DB Destination" (22)"
wrote 10 rows.
Info: 2013-10-27 23:38:03.50
Code: 0x4004300B
Source: extract
SM workorders SSIS.Pipeline
>
Description: "component "OLE DB Destination"
(22)" wrote 6 rows.
Info: 2013-10-27 23:39:07.15
Code: 0x4004300B
Source: extract
SM workorder activity SSIS.Pipeline
>
Description: "component "OLE DB Destination"
(22)" wrote 11 rows.
#Section in bold are the ones which are desired
I want
the output in such a format
Date
Error
Row Count
2013-10-27
extract SM ticket xref
10
2013-10-27
extract SM workorders
6
2013-10-27
extract SM workorder activity 11
Please
help me as i tried many thing but unable to get this 🙁