Post reply

ODBC Connection Manager

  • July 7, 2008 at 9:26 am

    #123756

    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

    #839385

    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

    #839393

    Hi (pritesh I think) thanks very much - worked a treat.

  • December 18, 2009 at 7:41 am

    #1094023

    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

    #1094137

    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:

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/634e69ca-bf93-409e-9e08-896447ad2a24

    [font="Comic Sans MS"]--
    Sabya[/font]

  • August 9, 2012 at 11:40 am

    #1524003

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy