Hello - I did a brief search on this subject and did not find anything in
Here's my problem:
I have a series of text files which all have the same format and structure.
They are files my company receives on a daily basis and uploads for use on
that day. The files do not feature a date field but the date they are for is
identifiable via the file name, e.g., EXT30_20010518.txt would be today's.
As is typical we now need to do historical analyses using these files but
since they do not feature a date column any uploaded files would be
meaningless in their current format. I need to add a date field and extract
the date from the file name. To your knowledge, can I do this via a DTS
transformation? (Even if I could simply get the file name in a column I
could do parsing in SQL).
Any tips, help or resources would be greatly appreciated. Thanks for your