• Im not totally sure what you're doing with SSIS but if the intention is to loop through a list of files and import its data into a table, this is how I'd do it:

    In the control flow use a For each loop container to loop through the files, set each filename to a global variable

    Inside the For each loop container use a Data Flow Task

    Inside the Data Flow task Use a Flat File Source using the filename stored in the variable

    Connect the Flat file source to a script component which would read the file date and set the date to an extra output from the script component

    Connect the Script component output to the preferred Destination component (ADO/OLE Db etc..) and store the data, including the new data field

    .................................................................................................................................................................

    Linkedin profile[/url]