December 3, 2008 at 4:19 am
I will appreciate if some one can help me in importing ODBC data into SQL server 2005 through Visual Studio Integration package. Apparently, Control flow does not have any ODBC connection control to import data.
Thanks
December 3, 2008 at 4:39 am
When you create a new data source connection there are three options in the provider drop down list. Choose the .Net providers option, then choose odbc data provider. You will then be asked to enter your data source connection information - either an ODBC data source created at the OS level or a connection string.
December 3, 2008 at 4:41 am
When you create a new datasource you can select ODBC data.
[font="Verdana"]Markus Bohse[/font]
December 3, 2008 at 6:49 am
Thanks for your reply.
I have created the data sources through connection manager. Connections are there. Now my problem which control I should use to import ODBC connection data in data control. In data flow there are
Pointer
Data Reader Source
Excel Source
Flat File source
OLE DB source
Raw File Source
XML Source
But none which pull out ODBC data. I can see all the tables in server explorer. How I can automate a task to pull data from this ODBC connection (CAche Database) and add them to SQL server 2005.
I will highly appreciate any help.
December 3, 2008 at 6:52 am
Choose the Data Reader source for ODBC.
December 3, 2008 at 7:02 am
I have a connection called TP for ODBC. I can test it and it tested well. When I try using it in Data Reader Source. It produces the folowing error. I don't know what else I should configured In "Advanced Editor For DataReader Source".
ERror Produced
Error at Data Flow Task [data Reader Source[1]]: Cannot acquire a managed connection from the run time connection manager.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply