Reading Text in sql

• peer_mohamed2k

  Mr or Mrs. 500

  Points: 510

  More actions

  July 16, 2008 at 5:22 am

  #191013

  Hi,

  I have text file having 2000 rows. These rows may start with 'Msg' or 'Bulk' values. This is the error output file from sql.

  I want to read this and insert rows starting with 'Msg' into a table in sql.

  I am trying this in sql only. Bulk insert will not work for this scenario, since we can't check the row starting value.

  Please suggest ur ideas if anyone faced this.

  Thanks,

  Peer Md.

• Kent Waldrop

  Hall of Fame

  Points: 3064

  More actions

  July 16, 2008 at 6:03 am

  #843706

  One method is to use the OPENROWSET command to read the data and then filter the records out of this query. Another alternative that you don't seem to want is to use BULK LOAD to load all of the records into a table and then process the data out of the "stage" table to fetch the desired records. You might also want to consider creating an SSIS package to import your data.