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
Error at Load Data [Raw File Source ]: 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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.