steps to import txt file

Question

steps to import txt file

SSCrazy

Points: 2601

July 16, 2004 at 8:10 am

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.

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

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

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 1

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

vision59 SSCrazy Points: 2601 More actions · Answer 2

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