Member Avatar for moone009
moone009 0 Junior Poster in Training

BIDS 2005 DEV Ed

I am working on a simple SSIS Package that parsers through a folder and uploads certains flat files data to certains databases.

TextFile syntax example: CustomerData1213.txt;CustomerData1513.txt;CustomerData3313.txt;CustomerData1323.txt

I am using a sql task that pushes file names from a table to the foreach loop (ADO Enumerator). However alot of the times when this data gets pushed to the folder I am parsing through the users end up adding timestamps to the file name. For example CustomerData1213.txt now become CustomerData1213_20120508_200519.txt

I have tried loading the filename in my table as CustomerData1213.txt;CustomerData1213.txt;CustomerData1213 but still no luck when they add the timestamp on to the file.

Do I need to add some type of expression to my loop or something?

Any ideas......Im sure someone has had to of encountered this :)

  • 1 Contributor
  • 0 Replies
  • 88 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.