ODBC DATA FLOW SOURCE...!!!

HI EVERYONE...!!

I WANT TO CREATE A DATA FLOW SOURCE ON ODBC TO SQL BUT A CAN'T FIND THE ODBC DATA FLOW SOURCE. SOMEBODY CAN SAY ME HOW DO THIS?

THANKS...!!!

Hi,

To create a ODBC Data Flow Source, first create a ODBC Connection Manger by right-click in the Connection Managers (below) pane and select "New Connection" and then select ODBC. Now you will be able to create ODBC connection for various sources.

Pls revert for any more clarifications.

Thanks & Regards,

Prakash Srinivasan.

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

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
Wenyangsql

Obtaining the last record

Let's say I need to be able to dynamically retrieve the last record in a table (ChData) in order to be able to continuously monitor the flow of data. Since theoretically there is no such thing defined in SQL, let's say I have an index column - ChTimestamp - (which, for some odd reason, is a DOUBLE), which grows monotonically. Thus, I want the row with the largest ChTimestamp value. The data columns would be Ch0, Ch1, and so on. Let's also assume that for some reason I am limited to using the LabVIEW database connectivity toolkit and because of that, I don't have full use of the SELECT statement but I have to supply the table and column names for the "SELECT FROM " and only the WHERE and the like predicates can be freely specified (I don't know how freely). What would be an elegant query to achieve the desired result? Thanks!
Kamenelegant query to achieve your result:select phonenumber
from dbms_vendors
where dbms in ('sql server','oracle','mysql','postgresql','sybase','db 2')
sorry, couldn't help it

:cool:|||select * from chdata
where
chtimestamp=(select max(chtimestamp) from chdata)

or am I missing something?

Alternatively you could write a trigger to update a known row in another version of the table with a single row so you can have a simpler where clause.

select * from mystupidtable where x='1'|||SELECT TOP 1 * FROM Table1 ORDER BY chTimestamp DESC|||Thank you very much, LoztInSpace and Peso. No it's not a homework, I'm a professional, it's just that I have to deal with so many different technologies, programming languages, APIs, etc., that sometimes it's just easier (not to mention quicker) to ask those who deal with it every day instead of trying to jump start my fried brain. :o

Kamen :angel:|||Maybe it is time to make your niche?|||Actually, small companies appreciate multivalent engineers like me. Plus, I'm too old to change. :cool:
Kamen