Microsoft Office Tutorials and References
In Depth Information
Figure 1-18. Enabling the Data Flow Task panel
Clicking the link “No Data Flow tasks have been added to this package. Click here to
add a new Data Flow task” (shown in Figure 1-18 ) enables the Data Flow task pane,
where you can build a data flow by dragging and dropping the tool box items as shown
in Figure 1-19 . Add an ADO NET Source from the SSIS Toolbox to the Data Flow Task
panel as shown in Figure 1-19 .
Figure 1-19. Adding a data flow source in SSIS
Double-click aDO net source to launch the source editor dialog. Click the new
button to create a new Connection Manager.
the list of data connections will be empty the first time. Click the new button again, and
connect to the server using one of the authentication models available.
select or enter a database name—adventureWorks in this example—and click the test
Connection button as shown in Figure 1-20 . On success, click OK twice to return to the source editor dialog.
Search JabSto ::

Custom Search