How does DESelect handle errors in SQL queries?

DESelect has a lot of functionality to try to prevent errors from happening in the first place.

For example, on the Target Definition screen, DESelect provide all kind of warnings in the mapping section to make sure the user creates a mapping the minimizes the chance of errors. DESelect will warn when:

• a user maps fields of different field types
• the Target Data Extension field's length is shorter
• a required field is not mapped or mapped with a field that may contain null values

Despite the above, there are still errors that could occur during runtime that can not be detected beforehand. If such error occurs the user will be notified:

• If an error occurs during Preview: error is shown on the preview screen.
• If an error occurs during Run: status icon of the selection on the Home page will be a red warning icon. Click on the red warning icon to see the details of the error.

DESelect will also provide as much useful information to the user as possible, typically more than what Marketing Cloud would return.

If an error occurs, the whole transaction will be reverted and no results will be written to the Target Data Extension.