Post reply

Excel source task fails saying source file does not exist

  • February 10, 2010 at 12:00 pm

    #145125

    Hi All,

    I have a package which contains a data flow task to read Excel file and populate a DB table. Excel source task will read input file from the INPUT folder and process them and at the end it will move the processed input files to the Archieve folders. So, some times there will not be any input files present (if support team does not populate new input files) in the INPUT folder and my package thorws error that source file does not exit.. Any one knows how to fix this issue? I wanted to make package run irrespective of whether input file present or not

    Thanks in advance.

    Suresh

    Regards,
    Suresh Arumugam

  • February 10, 2010 at 12:32 pm

    #1117082

    Put your dataflow in a Foreach container ...

    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

  • February 11, 2010 at 1:17 am

    #1117419

    Thanks for your reply.

    My Data Flow task is in For Each Loop container only. But still it says that "check that the object exists". Please help.

    I wanted my package to run successfully even with out any input files present in the INPUT folder.

    Thanks all,

    Suresh

    Regards,
    Suresh Arumugam

  • February 11, 2010 at 1:23 am

    #1117424

    You might try setting DelayValidation/ValidateExternalMetadata to True/False on your Source.

    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

  • February 11, 2010 at 1:37 am

    #1117432

    Where and when do you get the error? Can you post your package or some screenshots?

    To make the package successful, raise the MaximumErrorCount property at the package level.

    You may also find this task interesting (never tried it).

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]

  • February 11, 2010 at 1:38 am

    #1117433

    Thanks a lot!

    It worked as expected.

    Regards,

    Suresh

    Regards,
    Suresh Arumugam

Viewing 6 posts - 1 through 5 (of 5 total)

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