SSIS

Checkpoints with containers in SSIS

In the previous post “Using checkpoints in an SSIS package“, we discussed how to configure an SSIS package in order to enable the checkpoints. Now, In this post “Checkpoints with containers in SSIS“, we are going learn how to configure a package to restart from the first task of the container in which it fails instead of

Checkpoints with containers in SSIS Read More »

Using checkpoints in an SSIS package

Checkpoints in SSIS In this post “Using checkpoints in an SSIS package”, we are going to learn how to configure checkpoints in an SSIS package. SQL Server integration services use checkpoints in order to avoid the re-execution of an SSIS package from the beginning in case the package fails during execution. Checkpoints can be extremely useful in

Using checkpoints in an SSIS package Read More »

Get error column name in Data Flow Task in SSIS

How to get error column name and error description in Data Flow Task in SSIS During execution of an SSIS package, when a bad row comes in the data flow task, the task gets failed. However, most of the components (source, transformation, and destination) in the data flow task exposes an error output path which can

Get error column name in Data Flow Task in SSIS Read More »

Dynamic SQL in OLEDB source component in SSIS

The metadata could not be determined because statement contains dynamic SQL When we use a batch of T-SQL statements which contains dynamic SQL or uses temporary tables inside, in an OLEDB source component placed in a Data Flow Task of a SSIS package, we get an error during column names extraction because the source component gets failed to fetch the metadata (columns and their data types)

Dynamic SQL in OLEDB source component in SSIS Read More »