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]
> >
>
>