Monday, March 26, 2012

ODBC data flow source

How do I create a Data Flow Task with an ODBC Data Flow Source? I know how to create an ODBC Connection Manager (at the bottom of the screen). But, when creating the data flow task, what do I use for the source component ... what do I drag from the toolbox under Data Flow Sources? All I have on this list is: Pointer, DataReader Source, Excel Source, Flat File Source, OLE DB Source, Raw File Source, and XML Source.

All I want to do is simply copy data from an ODBC data source into a SQL Server table.

ThanksDataReaderSrc is the one you'll need to pull out data from a ODBC connection, point it to the ADO.Net:ODBC connection you created and set up the SqlCommand properly, then hook it up with a OLEDBDest adapter or a SQLServerDest.|||

Can Data Reader Source be customized(for examplae, use parameters)?

|||The SqlCommand in DataReaderSrc is expressionable - which means, you can set SqlCommand to sth like "select * from HumanResources.Employee where EmployeeID="+(DT_WSTR,1)@.myVar1. For setting expressionable properties for dataflow components, pls reference BOL, basically you need to set it at dataflow task's "expressions" property.

Thanks
Wenyang

No comments:

Post a Comment