2005 SSIS Package using ODBC

#1

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

#2

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.

--------------------

Quote:

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 (AT) newsgroup (DOT) 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 (AT) microsoft (DOT) 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!TK2MSFT NGXA03.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

#3

I was also having the same problem with just testing out simple ODBC
connections until I came across the following post

http://blogs.sqlxml.org/bryantlikes/...07/28/876.aspx

And this worked for me. Surely this suggests problems with the ODBC
connection manager not the ODBC driver its self?

Regards

Giles

"Peter Yang [MSFT]" wrote:

Quote:

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 (AT) newsgroup (DOT) 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 (AT) microsoft (DOT) 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!TK2MSFT NGXA03.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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2005 SSIS Package using ODBC

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

2005 SSIS Package using ODBC - 12-29-2005 , 08:37 PM

RE: 2005 SSIS Package using ODBC - 12-30-2005 , 03:36 AM

RE: 2005 SSIS Package using ODBC - 01-17-2006 , 04:33 AM