Sometimes you can cure this by setting each step in the transformation to "Execute on Main Package Thread".  You do this by right clicking on the step and select "Workflow...

You should also check to make sure the SQL Agent is logging in with the appropriate permissions. I've also seen this problem if you have problems with the version...