SQL Server Source Patterns - SQL Server Integration Services Design Patterns - page 131

Once you've picked the correct connection manager and provider, you need to use
them in a Source Component for our data pull. Begin by looking at the SSIS Tool-
box when you are on the Data Flow tab. If you have not rearranged the SSIS Toolbox,
you will see all possible sources under the Other Sources grouping, as seen in Figure
4-6 .
Figure 4-6 . Other Sources grouping in the SSIS Toolbox
Now it's time to choose one.
Most of the hard decision-making was already completed when you set up the con-
nection manager. If you use an OLE DB connection manager, then you must use the
OLE DB source. If you decided to use an ADO.NET connection manager with either
an ADO.NET or ODBC provider, you must use the ADO NET Source.
Once you drag the desired source onto the Data Flow design window, the data flow
contains one component, as shown in Figure 4-7 . Integration Services lets the deve-
loper know that there is an issue with the source by displaying the red circle with the
white X in it. In this case, the issue is that you have not yet set any of the source's
properties, starting with the destination table, as shown in the tooltip.