Export (0) Print
Expand All

Package.OfflineMode Property

Gets or sets a Boolean that indicates if the package is working in offline mode.

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

'Declaration
Public Property OfflineMode As Boolean
	Get
	Set
'Usage
Dim instance As Package
Dim value As Boolean

value = instance.OfflineMode

instance.OfflineMode = value

Property Value

Type: System.Boolean
A Boolean that indicates if the package is working in offline mode.

Indicates whether the package is in offline mode. If the package is in offline mode, the package does not acquire connections.

The following code example creates a package, sets the OfflineMode and InteractiveMode properties before adding a script task.

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.ScriptTask
 
Namespace Package_API
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim p As Package =  New Package() 
            p.InteractiveMode = True
            p.OfflineMode = True
 
            ' Add a Script Task to the package.
            Dim taskH As TaskHost = CType(p.Executables.Add(Type.GetType(Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask).AssemblyQualifiedName), TaskHost)
            ' Run the package.
            p.Execute()
            ' Review the results of the run.
            If taskH.ExecutionResult = DTSExecResult.Failure Or taskH.ExecutionStatus = DTSExecStatus.Abend Then
                Console.WriteLine("Task failed or abended")
            Else 
                Console.WriteLine("Task ran successfully")
            End If
        End Sub
    End Class
End Namespace

Sample Output:

Task ran successfully

Community Additions

ADD
Show:
© 2014 Microsoft