function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
darhdarh 

Informatica Data Loader termination problem

I'm trying to do account upserts from SQL Server using Informatica Data Loader. I keep getting:

 

[DTM_10004] The DTM process terminated unexpectedly.

 

Any ideas?

 

Best Answer chosen by Admin (Salesforce Developers) 
darhdarh

The culprit was using dashes in my SQL Server column names, even if I wasn't mapping to those fields.

 

I never would have figured this one out without help from the Informatica support team. Thanks, Mark!

All Answers

shillyershillyer

Have you tried Informatica support? Their listing mentions they offer email and phone support.

 

Hope that helps,

Sati

aalbertaalbert
You should be able to increase the log level on the Informatica processes to get more detailed error messages.
darhdarh

The culprit was using dashes in my SQL Server column names, even if I wasn't mapping to those fields.

 

I never would have figured this one out without help from the Informatica support team. Thanks, Mark!

This was selected as the best answer
sfdeveloper9sfdeveloper9

Hello darh I am having the same issue. Please let me know the solution.

 

Thanks,

YP