Post reply

Error using ForEach loop

  • June 9, 2009 at 12:28 am

    #222256

    Hi,

    I am trying to import more than one file in a singe table, using ForEach Loop container in SSIS.

    I am using one recordset in side the adta flow task.

    Data flow task is placed inside my Foreach loop container. But i am not able to provide VariableName inside the recordset destination.Can anyone help me out in this, or is there any other way by which i can loop ovr more than one file inside a folder.

    Thanks in advance

  • June 9, 2009 at 5:34 am

    #1006596

    You have multiple sources and 1 destination - so surely it is your source data which should be dynamic and the destination which should be fixed?

    Why not use a SQL Server destination?

    Error messages are often difficult to diagnose, even when you have them verbatim right in front of your eyes. You are just adding an unnecessary layer of difficulty by not telling us what yours is.

    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 2 posts - 1 through 1 (of 1 total)

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