ODBC Data Source

I hope that I am being a real dunce about this.
Using SSIS, I create an ODBC data connection to our transactional system,
from which we build our data warehouse. In the data flow, when I go to add
the data source, I find nothing that will reference the ODBC data connection
.
Suggestions?
StevenRight click on the data flow source and select edit. From
here you can enter the Connection Manager that you added.
What are you using as the Data Flow Source?
-Sue
On Tue, 23 May 2006 08:01:03 -0700, Steven
<Steven@.discussions.microsoft.com> wrote:

>I hope that I am being a real dunce about this.
>Using SSIS, I create an ODBC data connection to our transactional system,
>from which we build our data warehouse. In the data flow, when I go to add
>the data source, I find nothing that will reference the ODBC data connectio
n.
>Suggestions?
>Steven|||Sue,
Thanks for your response. Here is what I found after some digging. You use
a .Net Providers/ODBC data providers connection. You create it and then
configure it to use a system dsn. Within the dataflow, you access the
connection with a data reader source. You point it to the connection that
you configured. You control what is pulled by using the SQLCommand on the
component properties tab.
Simple enough once you know what to do.
-Steven
"Sue Hoegemeier" wrote:

> Right click on the data flow source and select edit. From
> here you can enter the Connection Manager that you added.
> What are you using as the Data Flow Source?
> -Sue
> On Tue, 23 May 2006 08:01:03 -0700, Steven
> <Steven@.discussions.microsoft.com> wrote:
>
>