Post reply

import text file to sql 2000

  • April 3, 2002 at 2:43 am

    #57781

    I have VB aplication that import Fixed length (Not delimited) text file in Sql server, using recordset but the process is very slow comparing to DTS. I need help on rewriting my apllication to use DTS with parameters as file name and file path.

    Thank you

  • April 3, 2002 at 4:24 pm

    #426567

    can't you use SQL Server's BCP instead, are you doing any formatting with thetext file? before the data from the file ends at its final destination?

    abdul


    abdul

  • April 10, 2002 at 8:28 am

    #426960

    quote:

    can't you use SQL Server's BCP instead, are you doing any formatting with thetext file? before the data from the file ends at its final destination?

    abdul

    Actualy yes.

    Thanks

    Aziz

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply