Frends.MicrosoftSQL.ExecuteQueryToFile / 2.3.0
Summary
Streams a query's results straight into a file, so the rows never accumulate in the Process's memory, and reports how many were written.
Typical use — extracts too large to hold in memory, where the plain query Task would exhaust the agent
Input class usually contains parameters that are required.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| Query | String |
– | SELECT * FROM table |
Query to execute. |
| QueryParameters | SqlParameter[] |
– | [ { Name = test, Value = test_value, SqlDataType = SqlDataTypes.Auto } ] |
Query parameters. |
| ConnectionStringSecret | String |
"Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;" |
Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword; |
Database connection string. |
| OutputFilePath | String |
– | C:\path\tp\file.csv |
Output file path. |