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

help with mangeddts Expand / Collapse
Author
Message
Posted Sunday, October 24, 2010 2:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 12:48 PM
Points: 36, Visits: 152
hi, I try to create this object, but I Had error :
$obj= new-object Microsoft.SQLServer.ManagedDTS "$ServerName"

error - "can't find type [ Microsoft.SQLServer.ManagedDTS ] : make sure the assembly containing this type is loaded "

thank's for the help.
Post #1009735
Posted Thursday, October 28, 2010 12:27 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:39 PM
Points: 15,489, Visits: 27,875
I'm pretty sure it's because that reference is incorrect. Microsoft.SqlServer has two other classes. Server and Management, in PowerShell. I suspect you'll have to create the object a different way.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1012569
Posted Thursday, October 28, 2010 12:29 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:39 PM
Points: 15,489, Visits: 27,875
Actually, I'm right. You can't load it that way. Here's a discussion on the Microsoft forums.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1012571
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse