Visual studio is installed on the server where sql server resides. The DSN is setup on the machine and running the package in debug mode works. I have to assume that permissions are correct because it runs this way.