Connections.Remove Method
ConnectionManager オブジェクトを Connections コレクションから削除します。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (microsoft.sqlserver.manageddts.dll 内)
構文
'宣言
Public Sub Remove ( _
index As Object _
)
public void Remove (
Object index
)
public:
void Remove (
Object^ index
)
public void Remove (
Object index
)
public function Remove (
index : Object
)
パラメータ
- index
削除する ConnectionManager オブジェクトの名前、インデックス、または ID です。
使用例
次のコード サンプルでは、コレクションから、新しく追加した ADO.NET 接続マネージャを削除します。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Connections_Collection
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples.
string mySample = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
// Create an application and load the sample.
Application app = new Application();
Package pkg = app.LoadPackage(mySample, null);
Connections myConns = pkg.Connections;
// Show how many connections are in the package.
int myConnsCount = myConns.Count;
Console.WriteLine("The number of connections is: {0}", myConnsCount);
// Add an OLEDB connection manager.
ConnectionManager myConn = pkg.Connections.Add("OLEDB");
myConn.Name = "My OLEDB ConnectionManager";
myConn.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Auto Translate=False;";
// Verify the addition of one connection manager.
myConnsCount = myConns.Count;
Console.WriteLine("The number of connections now is: {0}", myConnsCount);
// Write out the names of the connection managers.
foreach (ConnectionManager myCMgrs in myConns)
{
Console.WriteLine("Name: {0}", myCMgrs.Name);
Console.WriteLine("ID: {0}", myCMgrs.ID);
Console.WriteLine("--------------------------------------------");
}
// Remove the connection manager by name.
pkg.Connections.Remove("My OLEDB ConnectionManager");
// Verify the removal of the connection manager.
myConnsCount = myConns.Count;
Console.WriteLine("The number of connections is finally: {0}", myConnsCount);
// Using the Contains method, verify if the connection is in the collection.
Boolean connRemoved = myConns.Contains("My OLEDB ConnectionManager");
Console.WriteLine("The connection is still in the collection? {0}", connRemoved);
Console.WriteLine();
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Connections_Collection
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples.
Dim mySample As String = "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
' Create an application and load the sample.
Dim app As Application = New Application()
Dim pkg As Package = app.LoadPackage(mySample,Nothing)
Dim myConns As Connections = pkg.Connections
' Show how many connections are in the package.
Dim myConnsCount As Integer = myConns.Count
Console.WriteLine("The number of connections is: {0}", myConnsCount)
' Add an OLEDB connection manager.
Dim myConn As ConnectionManager = pkg.Connections.Add("OLEDB")
myConn.Name = "My OLEDB ConnectionManager"
myConn.ConnectionString = "Data Source=.;Initial Catalog=AdventureWorks;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Auto Translate=False;"
' Verify the addition of one connection manager.
myConnsCount = myConns.Count
Console.WriteLine("The number of connections now is: {0}", myConnsCount)
' Write out the names of the connection managers.
Dim myCMgrs As ConnectionManager
For Each myCMgrs In myConns
Console.WriteLine("Name: {0}", myCMgrs.Name)
Console.WriteLine("ID: {0}", myCMgrs.ID)
Console.WriteLine("--------------------------------------------")
Next
' Remove the connection manager by name.
pkg.Connections.Remove("My OLEDB ConnectionManager")
' Verify the removal of the connection manager.
myConnsCount = myConns.Count
Console.WriteLine("The number of connections is finally: {0}", myConnsCount)
' Using the Contains method, verify if the connection is in the collection.
Dim connRemoved As Boolean = myConns.Contains("My OLEDB ConnectionManager")
Console.WriteLine("The connection is still in the collection? {0}", connRemoved)
Console.WriteLine()
End Sub
End Class
End Namespace
サンプルの出力 :
The number of connections is: 3
The number of connections now is: 4
Name: Create_Execute_Process_Dest.sql
ID: {B52C0D78-5402-4544-BFEC-2BE203900C91}
--------------------------------------------
Name: customers
ID: {4F945623-B43F-470F-9D1E-D2A0B09177AE}
--------------------------------------------
Name: localhost.AdventureWorks
ID: {47179DDF-BD08-4E29-87C4-3A3D77105C2B}
--------------------------------------------
Name: My OLEDB ConnectionManager
ID: {90DF568E-ECB1-46D2-8DCB-3E2C67391E64}
--------------------------------------------
The number of connections is finally: 3
The connection is still in the collection?False
スレッド セーフ
この型の public static (Microsoft Visual Basic では共有 ) メンバは、スレッド セーフです。インスタンス メンバの場合は、スレッド セーフであるとは限りません。
プラットフォーム
開発プラットフォーム
サポートされているプラットフォームの一覧については、「SQL Server 2005 のインストールに必要なハードウェアおよびソフトウェア」を参照してください。
対象プラットフォーム
サポートされているプラットフォームの一覧については、「SQL Server 2005 のインストールに必要なハードウェアおよびソフトウェア」を参照してください。
参照
関連項目
Connections Class
Connections Members
Microsoft.SqlServer.Dts.Runtime Namespace