Hi Guys, I have Cache Transformation that produces a .caw and saved it in the directory folder. I used this file in a Lookup Transformation with cache mode to full. My question is there a way to clear the .caw file after every process? Thanks,

if you want to clear it, you can simply delete all content of file with this script: System.IO.StreamWriter sw = new StreamWriter(@"c:\folder\myCacheFile.caw", false); sw.Write(string.Empty); sw.Flush(); sw.Close(); http://www.rad.pasfu.com

if you want to clear it, you can simply delete all content of file with this script: System.IO.StreamWriter sw = new StreamWriter(@"c:\folder\myCacheFile.caw", false); sw.Write(string.Empty);http://www.rad.pasfu.com