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"

DECLARE @@DtsRunText varchar(64)

SET @@DtsRunText = ‘EXEC xp_cmdshell ‘'dtsrun /Ssomesql /Usa /Ppass /NTEST /A' + MyVar + ‘'''

EXEC(@@DtsRunText)

If MyVar is character, you'll have to add additional quotes before and after the insertion of the variable into the @@DtsRunText string.




nntp://news.sf.sbcglobal.net/microsoft.public.sqlserver.dts/<#xyQHxtXEHA.3552 (AT) TK2MSFTNGP12 (DOT) phx.gbl>

Hi All,

I finally got the DTS run to work with my new package thanks to Allan
Mitchell.... Now my question is this:

How do I pass the Dtsrun command line a variable?

EXEC xp_cmdshell 'dtsrun /Ssomesql /Usa /Ppass /NTEST /AMyVar:8=Mydata'

The above line works great as long as I hard code the value of MyVar.... my
challenge now is to put this in a stored proc and pass in the value of
MyVar.

So basically I need to deal with

CREATE PROCEDURE spGetParcelTrans
@TransNo int
AS
EXEC xp_cmdshell 'dtsrun /Ssomesql /Usa /Ppass /NTEST /AMyVar:8='

So how do I deal with MyVar & @TransNo ????

TIA

D. Johnson





[microsoft.public.sqlserver.dts]