Home > SSIS Best Practices > SSIS – Data Viewer

SSIS – Data Viewer

Data viewers are an awesome troubleshooting utility for SSIS.

Data viewers display data between two components in a data flow. Data viewers can display data when the data is extracted from a data source and first enters a data flow, before and after a transformation updates the data, and before the data is loaded into its destination.

  • Click the Data Flow task to whose data flow you want to attach a data viewer and then click the Data Flow tab.

  • Right-click a path between two data flow components, and select Data Viewers.

  • In the Data Flow Path Editor dialog box, click Data Viewers and then click Add.

  • In the Configure Data Viewer dialog box, do one of the following:

  • Grid, Histogram, Scatter Plot , Column Chart

    Categories: SSIS Best Practices
    1. No comments yet.
    1. No trackbacks yet.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

    %d bloggers like this: