Hello,

I am new to DTS and have been able to generate a package that will import the data that was unstructured from a text file into a table in one column.

In the format:

media_id = BEX300
density = dlt3 (21)
allocated = 06/24/2005 00:54:32 (1119570872)
last_written = 07/03/2005 23:37:48 (1120430268)
expiration = 08/01/2008 23:00:00 (1217628000)
last_read = N.A (0)
kbytes = 285083765
retention_level = 0
status = 0x8
vmpool = 35
res1 = 0

media_id = BEX308 ----and so on

how would I import the data after the = into a table which has been created with the headings infront of the =

please help cant figure it out been working with SQL satements but limited knowledge and success