-
DTS importing text file to table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|