none
error while reading raw file created in previous task using raw file destination

    Question

  • I am reading a flat file and creating an raw file using raw file destination.  path of the raw file is in a variable.  now I am reading the raw file using the rawfile source component. I am able to execute if the .raw file is available.  But when we deploy into the production the .raw will be created runtime, so the package is getting failed while evualting the variable which hold the path of the variable.  since the .raw is not available i am not able to proceed further. it's in ssis 2008 r2

    Error at Load Data [Raw File Source [401]]: File "c:\test123.raw" cannot be opened for reading. Error may occur when there are no privileges or the file is not found. Exact cause is reported in previous error message.

    Error at Load Data [SSIS.Pipeline]: component "Raw File Source" (401) failed validation and returned error code 0x80004005.

    Error at Load Data [SSIS.Pipeline]: One or more component failed validation.

    Error at Load Data : There were errors during task validation.

    Thursday, February 14, 2013 7:13 PM

Answers

  • Set delay validation = true on the dataflow component

    Chuck Pedretti | Magenic – North Region | magenic.com

    • Proposed as answer by latha521 Thursday, February 14, 2013 7:58 PM
    • Marked as answer by Prabakar TR Thursday, February 14, 2013 8:09 PM
    Thursday, February 14, 2013 7:54 PM