Stack Overflow
Stack Overflow

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
1
vote
1 answer

Create SSIS- SQL Task Oracle SQL Statement With WHERE Clause "IN" keyword

I really hope I can get some input on this. I'm trying to create an SSIS package with SQL Statement with "IN" in WHERE clause (ex: SELECT * FROM Oracle.Table1 WHERE Col1 IN (?) ). Basically, an Oracle SQL Statement with values from a SQL Server…
Jaji
  • 55
  • 5
1
vote
1 answer

SSIS - How to use results of Execute SQL Task to call a Web Service

I need to use a result from SQL SELECT which should return an array of IDs to iterate through it in my foreach loop. I'm quite new to SSIS. I created Execute SQL Task, connect to DB and write SELECT ID FROM TABLE Then I created Script Task and…
soldous
  • 111
  • 1
  • 9
1
vote
1 answer

Problem with execute a procedure in SSIS with execute SQL task

I write in three variables values from a DataBase using an Execute SQL task and if I check if values was correctly written with the breakpoint, everything seems to be correct. Now I want use the variables that were written before in an other execute…
MrCaptain Alex
  • 169
  • 1
  • 13
1
vote
2 answers

SSIS Precedence Constraint Not Working Due to Path Formatting

Using SSIS and MS-SQL Server 2012 I have a SQL Task executing: SELECT COUNT(id) as id FROM PORG_Files WHERE filename = ? It never returns anything except 0 because the SSIS filename looks like: \\\\erp\\shares\\Save\\item_1168.txt And the Filename…
Dizzy49
  • 1,360
  • 24
  • 35
1
vote
1 answer

Using Parameters at different points within For Each Loop Container

I have the following steps within the Control Flow, where WorkOrderID is used by the first Execute SQL task and InvoiceID used by the second script task. Can anyone spot what I'm doing wrong below as it is failing on the Update Invoice Status…
Philip
  • 2,460
  • 4
  • 27
  • 52
1
vote
1 answer

SSIS Looping with Return Value from Stored Procedure

I am trying to create a SSIS Package that loops based on the return value of a stored procedure run in the loop. I keep getting a super NOT helpful error of: "Error: 0xC002F210 at Load Order, Execute SQL Task: Executing the query "EXEC ? =…
Dizzy49
  • 1,360
  • 24
  • 35
1
vote
0 answers

ssis timeout when running Execute sql task

how to hand handled ssis timeout when running Execute sql task. in execute sql task ,I am calling the stored procedure connectiong type is oledb connection TImeout is 0 (infinity) I am getting the following error when I try to run in…
gbalu
  • 377
  • 4
  • 11
1
vote
2 answers

How to fix error - "No disconnected record set is available for the specified SQL statement."

I am executing a stored procedure to collect the data set into a variable of object type. The stored procedure has 2 parameters and works fine. When I use the same stored procedure in 'execute Sql task' in ssis I get the error message as "[Execute…
SW2018
  • 31
  • 1
  • 5
1
vote
2 answers

Stored proc in Execute SQL Task not persisting changes to database

I have an Execute SQL Task using an Update statement that I would like to change to a stored procedure. My stored procedure works fine in SSMS, however when I try and use the stored proc in the Execute SQL Task, the component doesn't fail, however…
user2989759
  • 279
  • 1
  • 4
  • 14
1
vote
1 answer

How to use 'Return Value' parameter in Execute SQL task

I know there are 3 types of parameter in 'Parameter mapping' - Input Parameter, Output Parameter and Return Parameter. I understand how to use Input and Output parameter. But when I try to set the parameter type as 'Return Parameter', it doesn't…
Ce Wu
  • 13
  • 1
  • 3
0
votes
1 answer

HI, I am not able to call redshift stored procedure in SSIS ExecuteSqltask

I am getting this error, while calling stored procedure of Redshift. we are using oledb connection Error: 0xC002F210 at Execute SQL Task 1, Execute SQL Task: Executing the query "call dev.proc_test" failed with the following error: "Undefined…
Saranya
  • 1
  • 2
0
votes
0 answers

I have an SSIS package with a SQL Task and a Data Flow Task and both are throwing connection errors

I have a SSIS package that I am running in VS2015 for testing. I connect to 3 different databases on 2 different SQL instances (default and a named instance). Running SQL2019 Standard. Any connection to the default instance run just fine. Any…
mikegrove
  • 1
  • 1
0
votes
1 answer

Microsoft Visual Studio 2019 Execute SQL Task Editor Syntax Errors Encountered

Trying to build a query on Execute SQL Task Editor. SELECT ? = CONVERT(VARCHAR(10), COUNT(DISTINCT Email)) FROM [xxx].[dbo].[DataTEST] AS D_Test INNER JOIN [xxx].[dbo].[ListsTEST] AS L_Test ON D_Test.ListId =…
Lulu
  • 1
0
votes
1 answer

How to add a red mark for a task in ssis package

I am creating a similar package to this package but I don't know the meaning of the red mark in the pic below, please help me
Tran Tuyet
  • 15
  • 7
0
votes
1 answer

SSIS/DTSX/ETL error: "The data in the reparse point buffer is invalid."

I have an SSIS/DTSX/ETL which is giving me the following error in a "Task" in the "Control Flow": [Execute SQL Task] Error: Executing the query "" failed with the following error: "Could not retrieve COM class factory for component with CLSID…
Iñaki L.
  • 9
  • 2
1 2
3
4 5