<div>
Here's the solution from the link by the way: &nbsp;Create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc. &nbsp;There is nothing intuitive about choosing this connection - but it worked for me. &nbsp;
</div>


Here's the solution from the link by the way:  Create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.  There is nothing intuitive about choosing this connection - but it worked for me.  

<div>
<div class="content wysiwyg-content">
I'm creating a new .dtsx package and have added a source I use all the time in the Connection Manager. &nbsp;If I test the connection to the source there I succeed. &nbsp;If I add a new Data Flow Task and try to use that connection as a DataReader source I get the following error:<br />
<br />
Error at Data Flow Task [Data Reader Source 715]]: Cannot acquire a managed connection from the run-time connection manager. &nbsp;<br />
<br />
I can open up complex .dtsx jobs in the same directory which use the same connection in Connection Manager and run them all day, and my credentials don't seem to be the problem. &nbsp;I have tried starting a new project for this and even copying an old one that works and deleting everything but a single Data Flow Task that includes a simple SELECT from the table I am using. &nbsp;Oddly the old jobs work fine, but I cannot create a new one.<br />
<br />
has anyone seen this kind of behavior before?
</div>
</div>


I'm creating a new .dtsx package and have added a source I use all the time in the Connection Manager.  If I test the connection to the source there I succeed.  If I add a new Data Flow Task and try to use that connection as a DataReader source I get the following error:

Error at Data Flow Task [Data Reader Source 715]]: Cannot acquire a managed connection from the run-time connection manager.  

I can open up complex .dtsx jobs in the same directory which use the same connection in Connection Manager and run them all day, and my credentials don't seem to be the problem.  I have tried starting a new project for this and even copying an old one that works and deleting everything but a single Data Flow Task that includes a simple SELECT from the table I am using.  Oddly the old jobs work fine, but I cannot create a new one.

has anyone seen this kind of behavior before?

DataReader Source &quot;cannot acquire a managed connection&quot; in Visual Studio

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

DataReader Source &quot;cannot acquire a managed connection&quot; in Visual Studio

DataReader Source "cannot acquire a managed connection" in Visual Studio