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.

Thanks

[516 byte] By [CraigN] at [2008-2-22]

«« How to call external function defined in microsoft jscript
»» Finding Containers and Variables from Script task?

# 1

DataReaderSrc 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.

Wenyang at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

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

IgorDeck at 2007-9-8 >

# 3

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

WenyangHu at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech