SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:11 PM
| ||||
| ||||
 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? Steven      |
|
02-27-2008, 09:12 PM
| |||
| |||
| Re: ODBC Data Source 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: >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? > >Steven |
|
02-27-2008, 09:12 PM
| ||||
| ||||
| Re: ODBC Data Source 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: > > >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? > > > >Steven > > |
Linear Mode
