locked
Bulkcopy RRS feed

  • Question

  • i need to import the data from .trc(trace file).W are useing following syntax.

    select  'TraceFile.trc'
        from dbo.Test
        where and ServerName = @ServerName

    insert into dbo.TraceInfo(txtData,
    TextData,
    BinaryData,
    DatabaseID,
    TransactionID,
    ServerName ,
    LineNumber )

    but it takes too much time to import the data. any othere better  method is there to save the time?

    Thanks.
    Best Regards,
    Sathiya.


    Thursday, March 20, 2008 1:50 PM

Answers

All replies

  • Have you tried using the SQLBulkCopy class?
    Thursday, March 20, 2008 4:21 PM
  • i have not tried SQLBulkCopy class. can you give me a sample code to get the data from .trc(trace) file using Bulkcopy?

     

    thanks

    Regards

    Sathiya.

    Friday, March 21, 2008 4:26 AM