Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

TransferSqlServerObjectsTask.CopyTriggers Property

Gets or sets a Boolean indicating whether triggers are included in the transfer from the source to the target database.

Namespace:  Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask
Assembly:  Microsoft.SqlServer.TransferSqlServerObjectsTask (in Microsoft.SqlServer.TransferSqlServerObjectsTask.dll)

public bool CopyTriggers { get; set; }

Property Value

Type: Boolean
true indicates that triggers are transferred from the source to the target database.



The default value is true.

Community Additions

© 2015 Microsoft