Hard to say without a bit more information, but quite often these sort of issues relate to permissions, so check that the package is running under the correct account and that this account has access to all the neccesary databases.
Also check you Logs as there will be a message in there that will give you some more information about the problem.