Post reply

steps to import txt file

  • July 16, 2004 at 8:10 am

    #65195

    I have text file which contain ID,Equip_serial, status_code. I need to import into Sql tbl called Equip. After importing I need to clear  data in status_code field than do comparsion with Equip_serial column in txt vs Equip_serial in Sql Equiptbl and put status_code data in status_code column of Equip SQl table.Thanks in advance for your input.

  • July 16, 2004 at 8:28 am

    #514866

    Use a simple Data Transform to import the file from text to a SQL table using DTS. Then use T-SQL to clear the data.

    update sql.equiptable set status_code = 0, space, whatever is "clear" for you.

    Then use T-SQL to move the data

    update sqlequiptable set status = b.status from importtable b where b.id = sqlequiptable.id

     

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • July 20, 2004 at 2:01 pm

    #515343

    steve.

    Thanks you for your info. How to  clear data of Serial no in Equip_info tbl. I want to clear data in this tbl and set status_code column in this tbl to 0 from NR. Then update tblEquip_info column  serial no from NRequip tbl serialno column.

    Thanks in advance

     

     

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

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