Home Forums Data Warehousing Integration Services Refresh flat file source columns from change in Foreach Loop Container RE: Refresh flat file source columns from change in Foreach Loop Container

  • March 7, 2018 at 1:35 pm

    #1982293

    Luv SQL - Wednesday, March 7, 2018 1:30 PM

    They do have all the same column names....I'm simply changed it from a bunch of *Summary*.csv files to *Detailed*.csv files (the destination has already been changed to reflect the new column names). 

    All of the Summary and Detail files are identical with the same columns, same number of columns, same data types.  It worked yesterday with my summary files and now won't work with the detail files.  Even with a SINGLE csv file (so there is no chance of any differences between the files) it does not run anymore.

    Can you confirm that you are using separate flat file sources for Summary and Detailed files and that you have one FEL for each (two FELs in total)? Also, that you have filtering in place on your FELs to avoid attempting to process files of the wrong type?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.