July 7, 2008 at 9:26 am
Hi, I'm trying to pull data from a Filemaker database into SQL.
I have set up an ODBC connection and tested it pulls data into Excel.
In SSIS I have created a .Net/ODBC connection, then I add a DataReader Source connection and set the Connection manager to the .Net/ODBC connection I tested earlier. I get this message from the DataReader Source...
Cannot acquire a managed connection from the run-time connection manager
Any ideas?
Allen
July 8, 2008 at 5:31 am
I think the type of connection manager you are using is not apt for the Data reader, try using the ADO.Net connection. When you right click on the connection managers pane , you get numerous options. Select "New ADO.Net connection". Write your connection string it that and test it.
July 8, 2008 at 5:39 am
Hi (pritesh I think) thanks very much - worked a treat.
December 18, 2009 at 7:41 am
I am working on pulling data from a Filemaker Pro database. I have my connection manager setup of and I can preview the data from SSIS, prior to populating my SQL Server DB. I get an error when I start to execute my package:
"The Select command property has not been initialized before Fill."
My SQL statement parse correctly from the Editor. Any clues?
Regards
December 18, 2009 at 9:52 am
dmaxj (12/18/2009)
I am working on pulling data from a Filemaker Pro database. I have my connection manager setup of and I can preview the data from SSIS, prior to populating my SQL Server DB. I get an error when I start to execute my package:"The Select command property has not been initialized before Fill."
My SQL statement parse correctly from the Editor. Any clues?
Regards
Did you check this:
[font="Comic Sans MS"]--
Sabya[/font]
August 9, 2012 at 11:40 am
Thanks, that was the problem!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply