This topic has not yet been rated - Rate this topic

DTSReadOnlyCollectionBase.CopyTo Method

SQL Server 2008 R2

Copies the entire DTSReadOnlyCollectionBase to a compatible one-dimensional array, starting at the specified index of the target array.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

C++

JScript

public void CopyTo(
	Array array,
	int index
)

Parameters

array: Type: System.Array
The one-dimensional http://go.microsoft.com/fwlink/?LinkId=27029 array that is the destination of the elements copied from DTSReadOnlyCollectionBase. The array must have zero-based indexing.

index: Type: System.Int32
The zero-based index in the array at which copying begins.

Implements

ICollection.CopyTo(Array, Int32)

Examples

The following code example is shows the Variables collection, which inherits from DTSReadOnlyCollectionBase, use a previously created package that contains variables to copy the variables into a new array using the CopyTo method.

Variable[] store = new Variable[pkg1.Variables.Count];
pkg1.Variables.CopyTo (store, 0);

Reference

DTSReadOnlyCollectionBase Class

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD