I have a directory structure consisting of a year with text files in each year directory ie
\2002\a.txt
\2002\h.txt
\2002\t.txt
\2003\a.txt
\2003\h.txt
\2003\t.txt
\2004\a.txt
\2004\h.txt
\2004\t.txt
Without manually creating a Text File(Source) for each individual file in the directory structure is anyone aware of a way to automate the import of multiple text files? The contents of each file is simply being read into SQL Server table via a 'Transform data Task'. Each text file has exactly the same structure.
Any help would be greatly appreciated.