problems checking for files in SSIS

  • Matthew Cushing

    SSCrazy

    Points: 2898

    I took at look at this component:

    http://www.sqlis.com/23.aspx

    and it's causing the same issue as this one:

    http://dichotic.wordpress.com/2006/11/01/ssis-test-for-data-files-existence/

    I have an excel file that I am trying to pick up and throw into a db. I am scheduling it for midnight every night, but if the file isn't there, I don't want to run the job.

    in both cases if the file isn't there I get this:

    TITLE: Package Validation Error

    ------------------------------

    Package Validation Error

    ------------------------------

    ADDITIONAL INFORMATION:

    Error at Import Workstatons [Excel Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.

    Error at Import Workstatons [Excel Source [1]]: Opening a rowset for "Workstations$" failed. Check that the object exists in the database.

    Error at Import Workstatons [DTS.Pipeline]: "component "Excel Source" (1)" failed validation and returned validation status "VS_ISBROKEN".

    Error at Import Workstatons [DTS.Pipeline]: One or more component failed validation.

    Error at Import Workstatons: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    if the file is there, then it works just fine. Is there a way to not do the connection managers until after the script runs? I have it set so that the script runs and if it succeeds, it calls the data flow. I am not sure that is what is happening.

    any ideas?

  • matzer

    SSCrazy Eights

    Points: 9727

    If you're using a data flow task to pick up the excel file and throw into a db, set the DelayValidation property of the data flow task to True. If the file isn't there the dataflow task wil not be validated since it will not run.

    Peter

  • Matthew Cushing

    SSCrazy

    Points: 2898

    I'm naming my next child Peter 🙂 Thanks for your help that was so frustrating and yet so easy to solve.

    Thanks!

    M@

  • saravanan_ma

    SSC Journeyman

    Points: 98

    Thanks a ton Peter. It helped me too. 🙂

  • Florian Schmidt

    SSC Enthusiast

    Points: 114

    I'm naming my next although child Peter 🙂

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

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