I am trying to import the performance monitor file (TSV)
into a SQL Server table. The performance monitor file is
in the TSV format.

When I try to import the data into the table listed below
I received the following error:

The number of failing rows exceeds the maximum specified
transform Date Time String 'DTS Transformation'
Destination 'Sample_Time': Cannot parse input data string
beginning at ""

Text File -> Microsoft OLE db provider for SQL Server

I'm using the Transform Data Task Properties in the
Transformation on the Sample_Time field. Next I select
create new 'Date Time String' then select properties with
this format MM/dd/yyyy hh:mm:ss.ffff tt

Please help me resolve this error.

Thanks,

Mike P.


Table Performance_Data
Column_Name Format
Sample_Time datetime
Page_Sec float
Full_Scan_Sec float

Performnace Monitor Data
06/29/2004 06:54:29.447" "135.66667198681353"
"6.8405065141770187"
"06/29/2004 06:55:29.460" "0.033326330515118213"
"2.1828746487402428"

Hi Mike,

The problem lies in the Date Time String that you have specified in the
Transform Data Task Properties for the Sample_Time field.

Instead of MM/dd/yyyy hh:mm:ss.ffff tt specify MM/dd/yyyy HH:mm:ss.ffff

This is because the source file contains the data in 24 hours format. The
HH would indicate hours in 24 hours format, whereas hh would indicate the
same in 12 hours format.


HTH

Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.