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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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