Facing connection issue while using ManagmentPlan - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Facing connection issue while using ManagmentPlan

Facing connection issue while using ManagmentPlan

Options

Previous Topic · Next Topic

raaz

Posted: Tuesday, July 31, 2007 4:18:10 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

Hi,

While i am trying to use Managementplan wizard getting the some connection error

Creating maintenance plan "MaintenancePlan" (Error)

Messages

Quote:

Create maintenance plan failed.

ADDITIONAL INFORMATION:

The connection type "ADO.NET:SQL" specified for connection manager "{2E6B9A84-F728-409D-8F0A-0159956C54AD}" 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.
(MaintenancePlan)

The connection type "ADO.NET:SQL" specified for connection manager "{2E6B9A84-F728-409D-8F0A-0159956C54AD}" 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.
(MaintenancePla

Please any body help to solve this...

Thanks In Advance..

raaz

Posted: Thursday, August 02, 2007 2:10:17 AM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

Hi,

Issue solved.

The SQL SERVER installed was build 9.0.1399. So installed Service Pack 2.

Now i am able to use the Integration Service Package Successfully.

Thanks

Scott Whigham

Posted: Thursday, August 02, 2007 9:08:25 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Good to know - thanks for posting the resolution

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.