Метод Package.ExportConfigurationFile
Creates an XML file that contains all deployable variables in the package.
Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)
Синтаксис
'Декларация
Public Sub ExportConfigurationFile ( _
str As String _
)
'Применение
Dim instance As Package
Dim str As String
instance.ExportConfigurationFile(str)
public void ExportConfigurationFile(
string str
)
public:
void ExportConfigurationFile(
String^ str
)
member ExportConfigurationFile :
str:string -> unit
public function ExportConfigurationFile(
str : String
)
Параметры
- str
Тип: System.String
The path to the configuration file.
Замечания
You can edit the configuration file and change the values for the computer-dependent variables. Each time the package is deployed to a different computer, it will use the computer-dependent variables on that computer when executing. For more information, see Создание конфигурации пакетов.
Примеры
The following example creates a new package, sets EnableConfigurations to true, and sets the ExportConfigurationFile property. The example then adds a new configuration to the package and sets the value of the ConfigurationString, ConfigurationType, and PackagePath.
static void Main(string[] args)
{
// Create a package and set two properties.
Package pkg = new Package();
pkg.EnableConfigurations = true;
pkg.ExportConfigurationFile(@"C:\conf.xml");
// Create a variable object and add it to the
// package Variables collection.
Variable varPkg = pkg.Variables.Add("var", false, "", 100);
varPkg.Value = 1;
string packagePathToVariable = varPkg.GetPackagePath();
// Create a configuration object and add it to the
// package configuration collection
Configuration config = pkg.Configurations.Add();
// Set properties on the configuration object.
config.ConfigurationString = "conf.xml";
config.ConfigurationType = DTSConfigurationType.ConfigFile;
config.PackagePath = packagePathToVariable;
//save the package and its configuration
Application app = new Application();
app.SaveToXml(@"c:\pkg.xml", pkg, null);
//Reload the package
Package p1 = app.LoadPackage(@"c:\pkg.xml", null);
//Review its Variables collection
Console.WriteLine("The value of variable VAR = " + p1.Variables["var"].Value);
}
Shared Sub Main(ByVal args() As String)
' Create a package and set two properties.
Dim pkg As Package = New Package()
pkg.EnableConfigurations = True
pkg.ExportConfigurationFile("C:\conf.xml")
' Create a variable object and add it to the
' package Variables collection.
Dim varPkg As Variable = pkg.Variables.Add("var",False,"",100)
varPkg.Value = 1
Dim packagePathToVariable As String = varPkg.GetPackagePath()
' Create a configuration object and add it to the
' package configuration collection
Dim config As Configuration = pkg.Configurations.Add()
' Set properties on the configuration object.
config.ConfigurationString = "conf.xml"
config.ConfigurationType = DTSConfigurationType.ConfigFile
config.PackagePath = packagePathToVariable
'save the package and its configuration
Dim app As Application = New Application()
app.SaveToXml("c:\pkg.xml", pkg, Nothing)
'Reload the package
Dim p1 As Package = app.LoadPackage("c:\pkg.xml",Nothing)
'Review its Variables collection
Console.WriteLine("The value of variable VAR = " + p1.Variables("var").Value)
End Sub
Sample Output:
The value of variable VAR = 1