ExecuteQueryToFile
Frends Task for executing Microsoft SQL queries into a file.
Last updated
Was this helpful?
Frends Task for executing Microsoft SQL queries into a file.
Task version: 2.3.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Source code: https://github.com/FrendsPlatform/Frends.MicrosoftSQL/tree/main/Frends.MicrosoftSQL.ExecuteQueryToFile
Query : String
Query to execute.
Default: -
Example: SELECT * FROM table
QueryParameters : SqlParameter[]
Query parameters.
Default: -
Example: [ { Name = test, Value = test_value, SqlDataType = SqlDataTypes.Auto } ]
🗝ConnectionString : String
Database connection string.
Default: "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"
Example: Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;
OutputFilePath : String
Output file path.
Default: -
Example: C:\path\tp\file.csv
TimeoutSeconds : Int32
Operation timeout (seconds).
Default: 30
Example: 30
ReturnFormat : ReturnFormat
Determines in what format the query is written.
Possible values:
CSV: Determines in what format the query is written.
Default: 0
Example: ReturnFormat.CSV
CsvOptions : CsvOptions
Csv options.
Default: -
Example: -
EntriesWritten : Int32
Amount of entries written.
Example: 2
Path : String
Path to the file.
Example: C:\test.csv
FileName : String
Name of the file.
Example: test.csv
Changelog for Task Frends.MicrosoftSQL.ExecuteQueryToFile.
Fixed an issue that was causing problems with Frends processes' cleanup and assembly unloading.
Improve execution of async methods.
Added Microsoft.SqlServer.Types dependency so that SqlGeography and SqlGeometry typed objects can be handled.
[Breaking] The task now uses Microsoft.Data.SqlClient instead of System.Data.SqlClient.
Fixed handling of null query parameters by changing the parameter value to DBNull.Value.
Initial implementation
Last updated
Was this helpful?
Was this helpful?