blogs.conchango.com

I've just been assigned some extensive SSIS work & am new to the new environment.  I've found this blog site extremely helpful trying to sort through everything.  I'm trying to use raw files to process the data, however I keep running into issues.

My package is creating the raw file at the beginning of the job using variables and I'm using FileNameVariable.  In the Data Flow, using the raw file as a source, the DelayValidation = True and the only other task is a row count .  The other Data Flow has DelayValidation = False.  Here comes the but...it's still giving me an error on the file name variable, cannot be opened for reading.

Is there something else I'm missing?  If I can't use a variable for the file name, I'll have to re-work everything to use a recordset which I'd rather not do and use DB resources.

Thank you for responding.  I hope this clears up what I have coded.

In the Control Flow window, the first executed data flow is named Retrieve Tran History.  This data flow retrieves the records from the DB and loads them into a raw file,  DelayValidation = false.  In the Control Flow window, the Retrieve Tran History is connected to another Data Flow named Get Tran History Row Count, with a green connection.  In this Data Flow, the Raw Source Component, Tran History Raw Input, has the DelayValidation = True.  However when I try to set AccessMode to File Name From Variable and the FileNameVariable to a User::WorkingLocation is gives me an error.  This variable has already been updated at the very beginning of the job.

Maybe I'm not understanding the above post.  Shouldn't I be able to set the DelayValidation to false when accessing the raw source that was created without an error displaying in the IDE?  Per the comment above, I don't have anything else with DelayValidation = false.

If I understand correctly, during development, I need the file to exist.  But I can replace the hard-coded file name with the variable before creating the production executable?

Thanks.