Post reply

Connecction manager error while executing package from SQL Server agent Job

  • March 10, 2015 at 4:52 am

    #298407

    I have created a package using Odata source as connection manager.I ran well in SSDT.I am trying to execute th e same package from Sql server agent job in step.it is throwing the below error.

    Description: The connection type "ODATA" specified for connection manager "SharepointData" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name. End Error

    using the below:

    SSMS 2012

    SSDT

    Please help

  • March 11, 2015 at 3:21 am

    #1783168

    I don't know anything about Odata, but are you trying to run the SQL Agent job on the same box as you successfully ran the package within SSDT? If not, then is there an Odata driver missing perhaps?

    Regards

    Lempster

  • March 12, 2015 at 1:04 am

    #1783517

    Ditto.

    Make sure the Odata adaptor is installed, if you are executing your SSIS from a different system.

    You can download it from here: http://www.microsoft.com/en-in/download/details.aspx?id=42280

    ____________________________________________________________

    AP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply