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)

[ReadOnlyAttribute(true)] 
public bool OfflineMode { get; set; }
/** @property */
public boolean get_OfflineMode ()

/** @property */
public void set_OfflineMode (boolean value)

public function get OfflineMode () : boolean

public function set OfflineMode (value : boolean)

Property Value

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.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.ScriptTask;

namespace Package_API
{
    class Program
    {
        static void Main(string[] args)
        {
            Package p = new Package();
            p.InteractiveMode = true;
            p.OfflineMode = true;

            // Add a Script Task to the package.
            TaskHost taskH = (TaskHost)p.Executables.Add(typeof(Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask).AssemblyQualifiedName);
            // Run the package.
            p.Execute();
            // Review the results of the run.
            if (taskH.ExecutionResult == DTSExecResult.Failure || taskH.ExecutionStatus == DTSExecStatus.Abend)
                Console.WriteLine("Task failed or abended");
            else
                Console.WriteLine("Task ran successfully");
        }
    }
}

Sample Output:

Task ran successfully

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2015 Microsoft