THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

SSIS Snack: Data Preview

Introduction

An easy-to-overlook function in an OLE DB Source adapter is the Preview button.

Dummy Data

To tinker with the Preview button, let's first create some dummy data in a Data Flow Task. There are a couple ways to create dummy data in a Data Flow, one way is to use an OLE DB Source. Drag it onto the data flow canvas and open the editor. Select (or create) a Connection Manager and set the Data Access Mode to "SQL command". Enter the following T-SQL statement:

Select 'A' as [Group], 112 as [Number]
union all
Select 'B', 219
union all
Select 'A', 111
union all
Select 'C', 311
union all
Select 'A', 117
union all
Select 'B', 211

Now that we have some dummy data, click the Preview button to get a look at a sample of the data returned - up to 200 rows:

This is some cool functionality - especially when I'm creating aggregates or invoking some Case logic.

:{> Andy

Published Wednesday, March 03, 2010 8:00 AM by andyleonard
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement