Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

problems checking for files in SSIS Expand / Collapse
Author
Message
Posted Thursday, January 10, 2008 1:42 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 21, 2014 10:22 AM
Points: 166, Visits: 387
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?
Post #441445
Posted Friday, January 11, 2008 5:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:21 PM
Points: 1,595, Visits: 6,620
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
Post #441672
Posted Friday, January 11, 2008 8:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 21, 2014 10:22 AM
Points: 166, Visits: 387
I'm naming my next child Peter :) Thanks for your help that was so frustrating and yet so easy to solve.

Thanks!
M@
Post #441800
Posted Thursday, June 19, 2008 2:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 28, 2014 1:20 PM
Points: 2, Visits: 42
Thanks a ton Peter. It helped me too. :)
Post #520225
Posted Tuesday, June 10, 2014 9:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:43 AM
Points: 24, Visits: 9
I'm naming my next although child Peter :)
Post #1579262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse