The account you use should also have access rights to the file and it's directory. If the username running the DTS package cannot write to the fiel, then it...

create a temp table and then use the value in that table as your global variable. This way it is always updated and is using the most currec name.