Two things are going on here, and they're not entirely independent but a few questions.

I assume you originally built this package from your local system, but the server is not local and is on the network somewhere. With that assumption, I'll keep going. If that's incorrect, please fill us in on the details.

Your SQLAgent on that server is probably set to localhost somethingorother instead of an actual NT network account. Thus, it's attempting to do an sa login and failing since the password isn't in the connection of the package you built. Secondly, the temp file it's looking for is being looked for locally on the server, not your system, so it can't function from the server.

What I would recommend doing is taking the dtsx package you've built, opening it up in BIDS, and getting the data source set to a more neutral location, such as a folder on a file system somewhere on the network. Next, if you're an admin on the server, get into the SQLAgent settings in the Services (Computer-Manage) and find out what login it's pretending to be.