I was able to get this to execute locally through business intelligence development studio but when I was scheduling this on our SQL server the job kept on failing.

After looking at the script provided in the article where it states:

"Dts.Variables("fileName").Value = System.IO.Path.GetFileName(Dts.Variables("fileName").Value.ToString())"

In order to get this to work on the server I simply had to remove the "System.IO.Path.GetFileName" leaving me with:

"Dts.Variables("fileName").Value = (Dts.Variables("fileName").Value.ToString())"

After making that change I was able to sucessfully use this SSIS package from the server.