First thing that comes to mind is that when you were debugging the package, you were running it from your computer. Then you tried running it from the server.
Does the server have the required driver?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]