dbTalk Databases Forums  

ODBC connection.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss ODBC connection. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sami
 
Posts: n/a

Default ODBC connection. - 05-23-2006 , 06:39 AM






Hello I can create a ODBC connection to another database which is not SQL
Server. But when I want to choose a Integration Service Destination
connection I am not given any ODBC connection type.

I would like to transfer and transform data from a SQL Server database to a
seperate database to which I already can create a connection.

Any help would be appreciated.

--
Regards,
Sami

[Remove Numbers from e-mail address to use it]


Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: ODBC connection. - 05-25-2006 , 08:50 PM






Do you mean from the Connection Manager in Integration
Services? Not sure what steps you are following but Right
click on Connection Manage area. Select New
Connection...Then select ODBC type connection from the
list.in the window and select add. That will bring up the
ODBC Connection Manager.

-Sue

On Tue, 23 May 2006 13:39:09 +0200, "Sami"
<s8a2m9i1_i5s1l9a6m (AT) hotmail (DOT) com> wrote:

Quote:
Hello I can create a ODBC connection to another database which is not SQL
Server. But when I want to choose a Integration Service Destination
connection I am not given any ODBC connection type.

I would like to transfer and transform data from a SQL Server database to a
seperate database to which I already can create a connection.

Any help would be appreciated.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.