Home Forums SQL Server 2005 SQL Server 2005 Integration Services ForEach Loop forEXCEL File RE: ForEach Loop forEXCEL File

  • December 2, 2008 at 2:56 am

    #906103

    SMAZ (12/2/2008)

    Yes, the source excel files are of same structure!

    Could you plz explain more in detail HOW TO SET EXCEL CONNECTION USING EXPRESSION?

    Thanks

    In SSIS simply add a new Excel data flow source in the data flow and connect this using the properties window.