Import multiple text files in DTS Package

• hydera

  SSC-Addicted

  Points: 410

  More actions

  August 22, 2005 at 11:09 am

  #69628

  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.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  August 23, 2005 at 4:50 am

  #584175

  This is a common problem and a solution with source code is available at http://www.sqldts.com/default.aspx?246

  SQL = Scarcely Qualifies as a Language

• cgunner

  Ten Centuries

  Points: 1118

  More actions

  August 23, 2005 at 7:54 am

  #584182

  Here is another good one:

  http://www.databasejournal.com/features/mssql/article.php/1461661