Post reply

SSIS -Foreach loop

  • January 18, 2012 at 1:48 am

    #263035

    Greetings team;

    I am new to this forum and BIDS as well; facing a problem with foreach loop container, i am transforming data from flat file source to OLEDB destinations with in the loop,

    the issue is i have two flat files in the folder wich was given to the loop, the data is inserting twice from one flat file, if i place three, thrice it is inserting the data from the first flatfile.

    pls advise

    regards

    venkat

  • January 18, 2012 at 1:58 am

    #1435038

    Seems like you havnt configured the variable correctly. Have you configured the package like this:

    http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

  • January 18, 2012 at 2:57 am

    #1435072

    click here and read the later half of the blog

    Raunak J

  • January 18, 2012 at 4:32 am

    #1435124

    Thanks i did not configured the variable correctly but now it works

    Thanks for your reply

    Regards

    venky

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

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