Setup

Overview

Data flow transformation, executing SQL command for each row in a data set. It is similar to the standard OLE DB Command transformation, however the executed SQL command is for the ADO.NET connection manager.

Setup

Overview

Data flow transformation to extract columns error information.

Introduction

Most of the SSIS data flow components have an error output that allows you to redirect rows that caused errors to a error logging destination. The quality of the information provided by the error output is rather limited. You get: the id of the column that's causing the error, the id of the error and all the input columns of the component. So what’s wrong with that?