Daily Archives: September 16, 2013

Loop Through Excel Files in SSIS

You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow task. First Create a variable named strExcelfile as a string variable; you can leave the value blank. Next, drag in … Continue reading

Posted in SSIS, Syndication | Tagged | 17 Comments