ScriptingOptions.FileName Property

 

Gets or sets the name of the file to which the generated script is output.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public string FileName { get; set; }

Property Value

Type: System.String

A String value that specifies the name of the file to which the generated script is output.

The following code example sets the name of the scripts output file.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.FileName = "C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\SampleFileName.sql"
Return to top
Show: