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]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/Sh...=70469&SiteID=1
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>
>|||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...
>|||Thank you very much for all your help.
Regards,
Sami
[Remove Numbers from e-mail address to use it]
"Sami" <s8a2m9i1_i5s1l9a6m@.hotmail.com> schrieb im Newsbeitrag
news:OPXbc4ygGHA.1260@.TK2MSFTNGP05.phx.gbl...
> 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]
>|||Thank you very much for all your help.
Regards,
Sami
[Remove Numbers from e-mail address to use it]
"Sami" <s8a2m9i1_i5s1l9a6m@.hotmail.com> schrieb im Newsbeitrag
news:OPXbc4ygGHA.1260@.TK2MSFTNGP05.phx.gbl...
> 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]
>