Whenever you run a SSIS package from the command-line you will see some output that looks similar to the following in your console window:
Or preferably you'll get this:
Have you ever wondered what that phrase "DTSER_SUCCESS (0)" or "DTSER_FAILURE (1)" actually means? It seems a strange thing to have output doesn't it? Well actually the explanation is all rather simple. The result of the package is defined by an enumeration called DtsExecResult which contains the execution result of a SSIS container (and remember, the package is in itself a container).
Here are the possible values of that enumeration (taken from Books Online):
| Member name | Description |
| Canceled | The task was cancelled. (Value = 3) |
| Completion | The task ran to completion. (Value = 2) |
| Failure | The task failed. (Value = 1) |
| Success | The task ran successfully. (Value = 0) |
So in other words, the success or failure of the package is more accurately described as the success or failure of the package container. Knowing that it is fairly straightforward to work out what DTSER_SUCCESS (0) means. "DTSER" stands for DtsExecResult, "SUCCESS" is the name of the enumeration member and the zero refers to the enumeration value for DtsExecResult.Success.
So there you go. Now you know.
-Jamie