| "Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
| news:rvBqizg3FHA.2904@TK2MSFTNGXA01.phx.gbl...

| >>"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
| >>news:3jmvOHc3FHA.2904@TK2MSFTNGXA01.phx.gbl...

"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:C%23L5Pir3FHA.1144@TK2MSFTNGXA01.phx.gbl...
> Hello Michael,
>
> Did you try to repair/reinstall VS 2005 to test the situation? Since it
> works fine in SS Management Studio, it shall be a integration issue
> between
> VS 2005 and its data connection components.
>
> Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
>
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --------------------
> | From: "Michael Tissington" <mtissington@newsgroups.nospam>
> | References: <OIzJ#FL3FHA.3052@TK2MSFTNGP10.phx.gbl>
> <3jmvOHc3FHA.2904@TK2MSFTNGXA01.phx.gbl>
> <e3gB6Xe3FHA.3244@tk2msftngp13.phx.gbl>
> <rvBqizg3FHA.2904@TK2MSFTNGXA01.phx.gbl>
> | Subject: Re: SSIS Connection
> | Date: Mon, 31 Oct 2005 08:17:29 -0800
> | Lines: 157
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | Message-ID: <#x9sWaj3FHA.2552@TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.dts
> | NNTP-Posting-Host: 65.249.55.7
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:15834
> | X-Tomcat-NG: microsoft.public.sqlserver.dts
> |
> | In SS Management Studio everything seems to work correctly.
> |
> | I have removed and reinstalled the software several times now :(
> |
> | --
> |
> | Michael Tissington
> | http://www.oaklodge.com
> | http://www.tabtag.com
> |
> |
> | "Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
> | news:rvBqizg3FHA.2904@TK2MSFTNGXA01.phx.gbl...
> | > Hello Michael,
> | >
> | > It seems that a BI developement tool issue. Please check if there is
> any
> | > issue when you creating connection directly in SQL server managememt
> | > studio. You could right click a database->tasks->Import data and check
> if
> | > you could create olddb datasouces there.
> | >
> | > If there is not any issues, you may want to reinstall SQL tools via
> | > Add/Remove programs to test the situation.
> | >
> | > Best Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================
> | >
> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> | > rights.
> | >
> | >
> | > --------------------
> | >>From: "Michael Tissington" <mtissington@newsgroups.nospam>
> | >>References: <OIzJ#FL3FHA.3052@TK2MSFTNGP10.phx.gbl>
> | > <3jmvOHc3FHA.2904@TK2MSFTNGXA01.phx.gbl>
> | >>Subject: Re: SSIS Connection
> | >>Date: Sun, 30 Oct 2005 22:40:26 -0800
> | >>Lines: 92
> | >>X-Priority: 3
> | >>X-MSMail-Priority: Normal
> | >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | >>X-RFC2646: Format=Flowed; Original
> | >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | >>Message-ID: <e3gB6Xe3FHA.3244@tk2msftngp13.phx.gbl>
> | >>Newsgroups: microsoft.public.sqlserver.dts
> | >>NNTP-Posting-Host: 65.249.55.7
> | >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:15822
> | >>X-Tomcat-NG: microsoft.public.sqlserver.dts
> | >>
> | >>Hello Peter,
> | >>
> | >>I go into SSIS create a new project, right click in the bottom panel
> to
> | >>create a new connection and choose any of the options (with the
> exception
> | > of
> | >>'New Connection')
> | >>
> | >>running regsvr32 for dtsconn.dll did not resolve the problem :(
> | >>
> | >>The only thing that works is New Connection - trying to create any
> other
> | >>type of connection fails
> | >>with the error about Connection Manager and
> | >>Microsoft.DataTransformationServices.Design.
> | >>
> | >>--
> | >>
> | >>Michael Tissington
> | >>http://www.oaklodge.com
> | >>http://www.tabtag.com
> | >>
> | >>
> | >>"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
> | >>news:3jmvOHc3FHA.2904@TK2MSFTNGXA01.phx.gbl...
> | >>> Hello MIchael,
> | >>>
> | >>> To understand the issue better, I'd like to know the detailed steps
> you
> | >>> reproduce the issue. Does it occur for any OLEDB provider?
> | >>>
> | >>> Based on my experience, you may want to see if you could workaround
> this
> | >>> problem by running:
> | >>>
> | >>> regsvr32 %ProgramFiles%\"Microsoft SQL
> Server\90\DTS\Binn\dtsconn.dll"
> | >>>
> | >>> Please let us know if you have any update. Thanks!
> | >>>
> | >>> Best Regards,
> | >>>
> | >>> Peter Yang
> | >>> MCSE2000/2003, MCSA, MCDBA
> | >>> Microsoft Online Partner Support
> | >>>
> | >>> When responding to posts, please "Reply to Group" via your
> newsreader
> so
> | >>> that others may learn and benefit from your issue.
> | >>>
> | >>> =====================================================
> | >>>
> | >>> This posting is provided "AS IS" with no warranties, and confers no
> | >>> rights.
> | >>>
> | >>>
> | >>> --------------------
> | >>>>From: "Michael Tissington" <mtissington@newsgroups.nospam>
> | >>>>Subject: SSIS Connection
> | >>>>Date: Sat, 29 Oct 2005 10:52:15 -0700
> | >>>>Lines: 21
> | >>>>X-Priority: 3
> | >>>>X-MSMail-Priority: Normal
> | >>>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | >>>>X-RFC2646: Format=Flowed; Original
> | >>>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | >>>>Message-ID: <OIzJ#FL3FHA.3052@TK2MSFTNGP10.phx.gbl>
> | >>>>Newsgroups:
> microsoft.public.msdn.general,microsoft.public.sqlserver.dts
> | >>>>NNTP-Posting-Host: 65.249.55.7
> | >>>>Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | >>>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:15814
> | >>> microsoft.public.msdn.general:5787
> | >>>>X-Tomcat-NG: microsoft.public.sqlserver.dts
> | >>>>
> | >>>>(not sure the best news group to post this)
> | >>>>
> | >>>>I'm trying to create a new OLEDB connection in the RTM version of
> SQL
> | > 2005
> | >>>>
> | >>>>I get back the following error
> | >>>>
> | >>>>The connection manager 'OLEDB' is not properly installed on this
> | > computer.
> | >>>>(Microsoft.DataTransformationServices.Design)