Hi,
Not a lot of info to go on .. you may find more info in the log. But first, when I can see the data in DM, but it fails in a job, that's usually an issue with not having saved your credentials.
Next, I would turn on additional logging per the documentation to get more information. I believe salesforce requires credentials and a token to connect.
Johnny
Principal Technical Training Consultant
Training and Technical Services, SAS Education
Tel: + 1 919 531 1223 ▪ Mobile: + 1 919 631 7635