"Peter Yang [MSFT]" wrote:

> Hello Tom,
>
> This seems to be a compatible issue between ODBC driver of the datasource
> and SSIS. What is the type of the database you want to connect? Could you
> find any oledb provider or updated odbc driver for the database? We saw
> similar issues when using some old DB2 OLEDB provider.
>
> 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.
>
>
> --------------------
> >Thread-Topic: 2005 SSIS Package using ODBC
> >thread-index: AcYM6eqRI08b+os+T7eBYKC4oEfrRg==
> >X-WBNR-Posting-Host: 68.67.208.184
> >From: "=?Utf-8?B?VG9tVA==?=" <tomt@newsgroup.nospam>
> >Subject: 2005 SSIS Package using ODBC
> >Date: Thu, 29 Dec 2005 18:37:02 -0800
> >Lines: 22
> >Message-ID: <E52B720C-8E10-46C6-BECF-5DA421C4246B@microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.dts
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.dts:62784
> >X-Tomcat-NG: microsoft.public.sqlserver.dts
> >
> >I'm trying to create a package based on an ODBC connection, to a legacy
> >accounting database.
> >
> >I've created a system DSN, which tests successfully. In the package
> >designer, I added a connection based on the DSN, and again it tests fine.
> >However, when I add a datareader, and use the connection, I get the
> following:
> >
> >Error at Data Flow task [DataReader Source[20]]: Cannot acquire a managed
> >connection from the run-time connection manager.
> >
> >I have on some occassions gotten the connection to work after I select it
> in
> >connection managers, and seen the table I was looking for (via a select*
> from
> >in the SQLCommand), however I still got errors which prevented me from
> going
> >any further.
> >
> >Any ideas as to how to get this working?
> >
> >thanks in advance,
> >
> >TomT
> >
> >
> >
>