RAW File Source with Variable File Name
I want to create a unique name for a raw file source every time I use it by embedding the Session GUID in the file name. The file would have been created earlier in the execution of the package using the same file name and I would delete it before the package execution was complete. The idea is to provide similar functionality to a SQL temp table. I thought that this would be simple, I would just sconfigure the file name to be in a Package Variable and evaluate it (as an expression) when the package ran. There are two problems with this, the file name does not exist as design time and the package fails validation for the same reason. What I am thinking of doing is keeping the file name in a package variable but evaluated as an expression. At design time, and during validation. the path and file name would point to a static sample file. A script, executed early in the life of the package would change the path to new location and embed a GUID in the file name. This would be used to create, read and delete the file. Am I on the right track? Are there any special timing issues or can I set the package variable as early as I like during package execution (after validation obviuosly)? Richard Campbell
November 15th, 2010 1:23am

you should set a default valid value for variable or set DelayValidation property of Data flow task to True. http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 1:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics