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