Tuesday, September 21, 2010

SSIS: [Send Mail Task] Error: Either the file "FileName" does not exist or you do not have permissions to access the file.

This is because when you create the file it put a lock on the file in SSIS.
Solution: Close the file using FileStream.Close() method.

FileStream File1 = new FileStream("C:\Text1.txt", FileMode.Create);
File1.Close();

No comments: