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. ...