problems checking for files in SSIS

Question

problems checking for files in SSIS

Matthew Cushing

SSCrazy

Points: 2898
More actions
January 10, 2008 at 1:42 pm

#377910

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?

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

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

matzer SSCrazy Eights Points: 9727 More actions · Answer 1

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