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)

public bool OfflineMode { get; set; }

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft