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"
[quoted text, click to view] <s8a2m9i1_i5s1l9a6m@hotmail.com> wrote:
>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.