Tag Archives: SSIS

In the SSIS data flow, many data flow components provide an ErrorOutput that allows you to route rows that generate errors or truncation to another component in the data flow.  The ErrorOutput path contains the following metadata: ErrorCode, ErrorColumn and … Continue reading →

SSIS provides functionality to handle unexpected data in the data flow.  Data flow errors are often due to invalid data values (e.g. string instead of number) and data truncation.  Many components in the data flow support error outputs that allow … Continue reading →

SSIS does not include an ‘out-of-the-box’ isNumeric( ) function.  Fortunately, this functionality can be implemented using the script component in the data flow. I am going to make the assumption that readers are familiar with the SSIS script component.  If … Continue reading →

SSIS logging is configured on a package-by-package basis.  SSIS provides a flexible event logging environment that allows developers to configure: the container or scope to log (generally the entire package), the type of events to log, and the log provider … Continue reading →

I discovered some undesirable behavior with the SSIS  Excel Data Source.  Although this issue has been well-documented for a while, I thought it is worth mentioning again. I had one column in my spreadsheet that was sparsely populated, nearly all … Continue reading →