https://wikitech.raphaelbrenet.com/ 2026-06-13T10:04:16+00:00 https://wikitech.raphaelbrenet.com/ https://wikitech.raphaelbrenet.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2022-05-02T10:07:54+00:00 Raphael (rafadmin@undisclosed.example.com) https://wikitech.raphaelbrenet.com/doku.php?id=ssis:ssis_run_sql_queries_in_script_task&rev=1651486074&do=diff SSIS - Run SQL queries from a Script Task Using OLEDB connection Run a query that returns data (SELECT): string connectionString = Dts.Connections["SqlServerConnectionName"].ConnectionString; string queryString = "SELECT col, COUNT(*) FROM schema.MyTable GROUP BY col" using (OleDbConnection connection = new OleDbConnection(connectionString)) { OleDbCommand command = new OleDbCommand(queryString, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); while (re… text/html 2022-02-12T11:06:08+00:00 Raphael (rafadmin@undisclosed.example.com) https://wikitech.raphaelbrenet.com/doku.php?id=ssis:ssis_display_info_from_script_task_component_fireinformation&rev=1644663968&do=diff SSIS - Raise event: FireInformation Display info from the script task in the output logs: bool fireAgain = true; Dts.Events.FireInformation(0, "Script Task Example", "Internet connection detected.", String.Empty, 0, ref fireAgain); Display info from the script text/html 2021-01-13T16:06:38+00:00 Raphael (rafadmin@undisclosed.example.com) https://wikitech.raphaelbrenet.com/doku.php?id=ssis:ssis_sql_query_on_excel_file&rev=1610553998&do=diff SSIS - SQL query on Excel file The general syntax is as follow: SELECT * FROM [SheetName$Range] WHERE condition If the option “first columns contains headers” is specified in the connection, the column names available in the query will be the ones from the Excel sheet. Otherwise, the dataset columns will be named F1, F2, F3