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]

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

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 (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:f0343b032956e8c851df501af0f0 (AT) msnews (DOT) microsoft.com...

Hello Sami,

If you have a read of the post link I sent you then it should help.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thank you very much!!

Do you know if MS are going to come up with a change to support ODBC
destination?

--
Regards,
Sami

[Remove Numbers from e-mail address to use it]
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:f0343b032962d8c851f35e770db0 (AT) msnews (DOT) microsoft.com...

Hello Sami,

No, I do not knoww. Given you can do it in a Script Transform as a destination
and ODBC maybe not being as prevalent as other forms of driver I suppose
not although like I said I do not know.

Maybe you could persuade someone to write a custom destination adapter to
do it?


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:

Thank you very much for all your help.

--
Regards,
Sami

[Remove Numbers from e-mail address to use it]
"Sami" <s8a2m9i1_i5s1l9a6m (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:OPXbc4ygGHA.1260 (AT) TK2MSFTNGP05 (DOT) phx.gbl...