Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

the connection type "MSORA" is not recognized as a valid connection name Expand / Collapse
Author
Message
Posted Saturday, May 10, 2014 11:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 10, 2014 11:43 AM
Points: 1, Visits: 0
hello ,
can anybody help me with the problem:
when I tried to run package from SQL Server management studio I get the error:

the connection type "MSORA" specified for connection manager "ConnectionToOracle" is not recognized as a valid connection name
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. Check the speling in the connection type name.

When I run the project from VisualStudio its runing well.

What can I do with it.

please, help.
Post #1569541
Posted Saturday, May 10, 2014 1:14 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:26 AM
Points: 2,532, Visits: 7,090
jnsosnowski (5/10/2014)
hello ,
can anybody help me with the problem:
when I tried to run package from SQL Server management studio I get the error:

the connection type "MSORA" specified for connection manager "ConnectionToOracle" is not recognized as a valid connection name
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. Check the speling in the connection type name.

When I run the project from VisualStudio its runing well.

What can I do with it.

please, help.


Quick questions, is this on the same system and what happens when you run the package with dtexec?
Post #1569550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse