Post reply

SSIS process multiple execl files

  • September 1, 2010 at 12:21 pm

    #227067

    I have to process several excel sheets with tab names Doctor and Nurse . For this I have used a foreach loop container and in it two dataflow tasks each for Doctor and Nurse .

    Everything works well , if the sheets contains both the tabs . But if a sheet dosnot contain both the tabs, then the package fails.

    Please help .

  • September 7, 2010 at 4:24 am

    #1217228

    ofcourse it will give an error...

    In the for each loop use a script task to check whether it contains the required tabs. if it contains then transform the data else divert by using an expression on the arrow.

    Thanks & Regards,

    Amar Sale

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

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

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