|
|
You're in the
sql server dts
group:Data Transformation.
sql server dts:
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... [quoted text, click to view] > Hello Sami,
> > > And what database type is your destination? > > You may find this post helpful > > http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=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] > > > >
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@no-spam.sqldts.com> schrieb im Newsbeitrag news:f0343b032962d8c851f35e770db0@msnews.microsoft.com... [quoted text, click to view] > 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 > > > 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. > > > > [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/ShowPost.aspx?PostID=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] > >>> > >
Hello Sami,
And what database type is your destination? You may find this post helpful http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=70469&SiteID=1 Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com [quoted text, click to view] > 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] >
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 [quoted text, click to view] > 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. > > [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/ShowPost.aspx?PostID=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] >>>
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 [quoted text, click to view] > Thank you very much!! > > Do you know if MS are going to come up with a change to support ODBC > destination? > > [Remove Numbers from e-mail address to use it] > "Allan Mitchell" <allan@no-spam.sqldts.com> schrieb im Newsbeitrag > news:f0343b032962d8c851f35e770db0@msnews.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 >>> 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. >>> >>> [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/ShowPost.aspx?PostID=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] >>>>>
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 [quoted text, click to view] "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/ShowPost.aspx?PostID=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] > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |