Questions tagged [execute-sql-task]

Execute SQL Task in SSIS is used to execute SQL statements or stored procedures in a relational database.

Execute SQL Task in SSIS is used to execute SQL statements or stored procedures in a relational database. This Task need a connection manager to establish a connection with a data source and it supports several data sources other than SQL Server.


References and helpful links

66 questions
0
votes
0 answers

Executing SSIS package using TSQL commands in visual studio

I am trying to execute the SSIS package using TSQL commands (as a part of asynchronous execution testing) using Execute SQL task but I am getting error with related to server authentication and connection not being made. Error: 0xC002F210 at…
0
votes
1 answer

SSIS execute sql statement multiple steps

In my SSIS pacakge I have an Execute SQL Task with 2 statements: statement 1: select coalesce ( max (id), 0)+1 as ID from AAA statement 2: Insert into BBB (id) values (?) In the first statement, I saved the result to an variable ID, and in the…
Kay
  • 175
  • 9
0
votes
1 answer

Insert only few columns from exec (SQL) when column name is not fixed

I have the below code: IF OBJECT_ID(N'tempdb..#VALS') IS NOT NULL BEGIN DROP TABLE #VALS END IF OBJECT_ID(N'tempdb..#Tbl_Eval_Temp') IS NOT NULL BEGIN DROP TABLE #Tbl_Eval_Temp END IF exists (select top 1 * from Tbl_Eval) BEGIN DROP TABLE…
Meen
  • 119
  • 3
  • 15
0
votes
1 answer

Extract result set from a execute sql task and store it in a excel file?

I have a execute SQL task, that needs two input variables and a output variable to run. The SP returns a table that i'm storing in ResultSet parameter. I want to store the values in this ResultSet parameter in a excel file. From my internet…
0
votes
1 answer

Error while trying to execute a stored procedure through "Execute SQL task" in SSIS

I have created a stored procedure. While trying to execute it through SSIS I'm running into problems. The definition of my stored procedure looks something like this: CREATE PROCEDURE dbo.[procedurename] @startDate DATETIME, @endDate…
Arpit Chinmay
  • 313
  • 5
  • 16
0
votes
1 answer

SSIS Execute SQL Task - multiple sources in sequence and not in parallel

I have a massive SSIS package with an Execute SQL task that reads data from 14 different sources, runs them through a Union All, and then through all the same transformations. Problem is, running 14 massive SELECTs in tandem is choking up the…
Ethan1701
  • 193
  • 1
  • 10
0
votes
1 answer

Execute SQL Task Error: Executing the query failed with the following error: "Incorrect syntax near ''."

I am working on a SSIS package that rejects already loaded files & load only new files to table. I used for each loop and exceute SSQL to validate if the files are already loaded. When I evaluate the expression of Execute SQL Task, it evaluates…
0
votes
1 answer

Active Directory Authentication using JWT Token connection string issue

I am trying to run a SQL script to create a user role in Azure SQL Database using the task Azure SQL database deployment by specifying the connection string with JWT token. From the Microsoft document I have tried the syntax in the DevOps task but…
0
votes
1 answer

Combining rows from multiple sources in Virtual list Filemaker

I am trying to make an Excel-like 'pivot table' in Filemaker using a Virtual List as the source of the data. The issue is I want to be able to have 'categories' down the first column that aren't fixed. The field names won't work. My current thought…
bdphifer
  • 13
  • 2
0
votes
0 answers

SSIS Error - Parsing Query from SQL Task Fails Due to 80040153, Invalid Value for Registry

Problem Statement I have a lot of SQL Server environments locally. When trying to parse a SQL task with very basic truncate table dbo.table syntax, I get the following error message. I should note that when I execute the task it works fine despite…
Ray's Web Presence
  • 464
  • 1
  • 5
  • 15
0
votes
1 answer

How to map multiple row results to different variables in SSIS Execute SQL Task?

I need to map 1 column frmm multiple result rows of SQL query with different variables in the same SSIS package. For example, the output of my query is: Category, Count A, 16 B, 23 C, 41 D, 72 E, 32 I want the value of Count to be…
user11647819
0
votes
0 answers

Overwrite of Excel destination using drop and create table statement in SQL task is not working properly. The new data is adding as new records

Actually I have designed the package to overwrite the excel destination with OLEDB data source. I have 5000 records in my SQL server DB table. First time when the SISS package executed same numbers of records are copied to excel destination. 2nd…
0
votes
0 answers

SSIS Not Inserting More Than One Row

I'm Using Execute Sql Task To Update Time Dimension I'm Using This Code declare @i int=isnull((select max(id) from DIM_DATE)+1,1) declare @Date Date=isnull((select [date] from dim_date where ID=@i-1),(SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) ,…
0
votes
0 answers

Connecting SSIS to excel via execute SQL task

I am encountering a frustrating problem with SSIS. The background is as follows: I have an excel file with 5 sheets - the first sheet is named "Meta" (the remaining 4 sheets are not relevant to this problem at hand) Inside the Meta sheet, I have…
0
votes
0 answers

SSIS Package Cant execute OPENROWSET Stored Procedure

Stored Procedure on SQL Server 2017 calls an OPENROWSET command to load a file from an .xlsx file. When running the Stored Procedure on the server it works fine and will load the xlsx rows into data tables. However when the SSIS package runs the…