August 14, 2007 at 4:36 pm
Hi everyone,
I just started reading a book about BI and it is saying "From the Toolbox, drag and drop an OLE DB Source Adapter from the Data Flow Sources group of components."
I only have Control Flow Items, Maintenance Plan Task in the Toolbox. In other pages of the book, I see that he also has Data Flow Transformations and Data Flow Destinations. How can I add these groups to the toolbox? Thanks in advance.
August 14, 2007 at 9:21 pm
You're still operating in the Control Flow, which is just that - it controls the flow of the package but doesn't actually handle the data flow. If there isn't one already there, drag and drop a Data Flow task onto the Control Flow pane. Then double-click the new Data Flow task, which will take you to the Data Flow pane. From there, you will see the source and destination adapters, along with the numerous transformations.
hth
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply