Post reply

Hor to find number of files processed via Foreach Loop Container

  • March 31, 2010 at 8:06 am

    #139064

    Hi,

    Now i created one package.Which loads data from flat files to sql server table.Source folder contains 4 files.I have been created a package, which is successfully importing data from flat files to a table.

    Now i want to get number of files and name of the files transferred to destination adapter.

    Can anybody suggest me in this regard.

    Thanks in advance

  • March 31, 2010 at 8:17 am

    #1143114

    Add an EXEC SQL task and write the data to a table, then query it later. Or use a script task to append the data to a string in some formatted manner.

    CEWII

  • March 31, 2010 at 8:18 am

    #1143116

    Wow, your post puzzled me for a while. I think you meant 'source folder', not 'destination folder', also 'importing' rather than 'exporting', as you are putting data into SQL Server, which is what this forum is all about:-)

    Why not create a logging table in the destination database (ID, Filename, LoadDate etc) and populate that as you iterate around your loop?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply