DTS importing text file to table

[nosepicker]

If, as you say, you already have the data in a one-column table, you can use this UPDATE statement to eliminate the text before the equals sign:

UPDATE YourTable
SET YourColumn = SUBSTRING(YourColumn, CHARINDEX('=', YourColumn) +2, LEN(YourColumn))