October 24, 2010 at 2:47 pm
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.
October 28, 2010 at 12:27 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
October 28, 2010 at 12:29 pm
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 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
Product Evangelist for Red Gate Software
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply