You can view the number of rows that failed to load into the target when you view the details for a job. For more information about the reason for each failure, view the error rows file.
To view job details, in Data Integration, select My Jobs and then click the job name. You can also view job details in Monitor on the All Jobs or Running Jobs page.
You can find the error rows files in the following directory:
If a job does not complete, you can stop the job on the All Jobs, Running Jobs, or My Jobs page.
Task errors
My task failed to complete and the following message appears in the job details:
DTM process killed for workflow [wf_dss_<workflow id>] session [s_dss_<session id>] because agent is shutdown.
The Secure Agent that was running the task was stopped or restarted while the task was in progress.
My tasks are failing after I installed a 64-bit Secure Agent on Windows. The following message appears in the job details:
Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent.
The Secure Agent machine that runs the task is missing the MSVCR.DLL files. Install the Microsoft Visual C++ 2008 Redistributable Package (x86) on the Secure Agent machine.
My task failed to complete and the following message appears in the job details:
The DTM process failed to start due to [CreateProcess error=14001, The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more detail]. 'Failed to run job because of missing VC++ libraries on the machine that runs the Secure Agent'
The Secure Agent machine that runs the task is installed on a Windows 2008 machine that is not correctly configured. Install the Microsoft Visual C++ 2008 Redistributable Package (x86) on the Windows 2008 machine.
The following error appears:
Unknown SQL datatype for field [<Object name.Field name>]. [<Number that represents the datatype>]
Data Integration does not recognize the data type of a source or target field.