SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:12 PM
| ||||
| ||||
 Data Transformation. Hello, I want to do some data transformation from one Database to another. My source DB is a MS SQLServer to which I can connect using OLEDB/SQLnative. My destination DB is a different type of database to which I can connect using Connection Manager. But for data transformation I need a destination connection. In the data pump area I don't have the option to choose an ODBC connection type. How can I connect to my destination database if there is no ODBC connection type to choose from in the Dataflow Tab??? Help. -- Regards, Sami [Remove Numbers from e-mail address to use it]      |
|
02-27-2008, 09:12 PM
| |||
| |||
| Re: Data Transformation. I am using SQLBase from Gupta. The only way to connect to the Database is over ODBC. But as I mentioned, if I choose to do a Data Transformation I don't have the option of choosing ODBC as my destination connection. -- Regards, Sami [Remove Numbers from e-mail address to use it] "Allan Mitchell" <allan@no-spam.sqldts.com> schrieb im Newsbeitrag news:f0343b032956e8c851df501af0f0@msnews.microsoft .com... > Hello Sami, > > > And what database type is your destination? > > You may find this post helpful > > http://forums.microsoft.com/MSDN/Sho...70469&SiteID=1 > > > Allan Mitchell > www.SQLDTS.com > www.SQLIS.com > www.Konesans.com > > > Hello, > > > > I want to do some data transformation from one Database to another. > > > > My source DB is a MS SQLServer to which I can connect using > > OLEDB/SQLnative. My destination DB is a different type of database to > > which I can connect using Connection Manager. But for data > > transformation I need a destination connection. In the data pump area > > I don't have the option to choose an ODBC connection type. How can I > > connect to my destination database if there is no ODBC connection type > > to choose from in the Dataflow Tab??? > > > > Help. > > > > [Remove Numbers from e-mail address to use it] > > > > |
|
02-27-2008, 09:12 PM
| ||||
| ||||
| Re: Data Transformation. Sami, Create a .Net Providers/ODBC data providers connection and configure it to use a system DSN that connects to your SQLBase. Within the dataflow, create a DataReader Destination and configure it to point the data connection that you created. On the second tab, you will have to supply the SQLCommand to write the data. Hope this helps. -Steven "Sami" wrote: > I am using SQLBase from Gupta. The only way to connect to the Database is > over ODBC. But as I mentioned, if I choose to do a Data Transformation I > don't have the option of choosing ODBC as my destination connection. > > -- > Regards, > Sami > > [Remove Numbers from e-mail address to use it] > "Allan Mitchell" <allan@no-spam.sqldts.com> schrieb im Newsbeitrag > news:f0343b032956e8c851df501af0f0@msnews.microsoft .com... > > Hello Sami, > > > > > > And what database type is your destination? > > > > You may find this post helpful > > > > http://forums.microsoft.com/MSDN/Sho...70469&SiteID=1 > > > > > > Allan Mitchell > > www.SQLDTS.com > > www.SQLIS.com > > www.Konesans.com > > > > > Hello, > > > > > > I want to do some data transformation from one Database to another. > > > > > > My source DB is a MS SQLServer to which I can connect using > > > OLEDB/SQLnative. My destination DB is a different type of database to > > > which I can connect using Connection Manager. But for data > > > transformation I need a destination connection. In the data pump area > > > I don't have the option to choose an ODBC connection type. How can I > > > connect to my destination database if there is no ODBC connection type > > > to choose from in the Dataflow Tab??? > > > > > > Help. > > > > > > [Remove Numbers from e-mail address to use it] > > > > > > > > > |
Linear Mode
