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: OLE DB Destination 1

Introduction

This SSIS Snack is a continuation of a couple previous SSIS Snacks:

Final (?) Destination

Drag an OLE DB Destination adapter from the toolbox onto the data flow canvas (if you haven't already). After connecting a data flow path from the output of the Conditional Split to the OLE DB Destination, double-click the data flow path and select the Metadata page.

 

Note this contains a definition of the "columns" in the data flow pipeline. 

Rename the OLE DB Destination adapter StageRows. Open the editor, select the destination connection manager and set the Data Access Mode property to "Table or view". Next (this is the cool part) click the New button beside the "Name of the table or view" dropdown.

The New button pops open a Create Table window populated with a CREATE TABLE statement. The table name comes from the name of the OLE DB Destination adapter, the column DDL is derived from the Data Flow Path's metadata (we saw this earlier). Isn't that cool?

As soon as you click the OK button, the DDL is executed and the table created.

:{> Andy

Published Monday, March 01, 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