Chapter 4 Quick Reference


Open table as spreadsheet

To

Do This

Open the SSIS project

In Windows Explorer, navigate to the project, and then double-click the file to open it in BIDS. In Solution Explorer, double-click a package to open it in design mode.

Create a data flow task

In BIDS, on the Toolbox menu, in the Control Flow Items group, drag Data Flow Task onto the Control Flow design surface.

Edit an object

In BIDS, on the design surface, double-click the object, and then change its properties as needed.

Create a data adapter

In BIDS, on the Toolbox menu, in the Data Flow Sources group, drag Flat File Source onto the Data Flow design surface.

Add a connection manager

In BIDS, on the Data Flow designer, double-click the data adapter. In the Editor dialog box, click New to create a new connection manager. Specify the file name, the file properties, and the file format.

Add a Conditional Split transformation

In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Conditional Split onto the Data Flow surface.

Add a Derived Column transformation

In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Derived Column onto the Data Flow design surface.

Add a Multicast transformation

In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Multicast onto the Data Flow design surface.

Add a Destination data adapter

In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag SQL Server Destination onto the design surface.

Create a task

In BIDS, on the Toolbox menu, in the Control Flow Items group, drag Data Flow Task onto the design surface.

Create a flat file

In BIDS, on the Toolbox menu, in the Data Flow Sources group, drag Flat File Source onto the design surface.

Add a lookup transformation

In BIDS, on the Toolbox menu, in the Data Flow Transformations group, drag Lookup onto the design surface.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net