SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS Denali Source and Destination Assistants

In several previous posts I have described some of the usability changes that will come with the next release of SSIS.


Data Flow Grouping

Resolve Reference

Today I’m going to introduce you to the Source and Destination Assistants that has been added to the Data Flow.  The idea behind these assistants is to make it easier for new comers to SSIS to get started faster.  Instead of the developer having to choose from the list of sources or destinations in the Data Flow they can simply user either the assistants to step them through the process.

To use the new assistants drag a Data Flow Task on to a package and open it.  You will now find in the SSIS Toolbox the Source Assistant, which you can use just by double clicking on it.  This walks you through the steps of choosing the correct type of connection as well as creating a Connection Manager if one does not exist previously.  The Destination Assistant works exactly the same way.  It is all an effort to make it easier to get started with SSIS.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


No comments.

Leave a Comment

Please register or log in to leave a comment.