Package.OfflineMode Property
SQL Server 2005
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)
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
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
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
