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
0
votes
2 answers

SSIS : Using SQLStatement output records as Full Result Set to feed into for each loop container

I am trying to use the output of a SQLStatement with Full Result Set Resultset from a SQL Task as an object to feed into foreach loop container. The SQL statement is SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME like 'Dim%' I want to…
PrinceKayastha
  • 115
  • 6
0
votes
0 answers

Creating an execute SQL task at runtime

I am working on a SSIS package which checks the performance of stored procedures using extended events. We have an execute SQL task having a SQL query which is determined at run time as the arguments for those (Read) stored procedures are already…
Nikhil Nilawar
  • 1
  • 2
0
votes
1 answer

DBCC command to reseed identity of table inside Execute SQL Task in SSIS

I have a situation in which a fact table is loaded every day. There are two SSIS packages that load this table. 1) Package1_FullLoad.dtsx - runs every Sunday, with a full refresh 2) Package2_DailyLoad.dtsx - runs on all days except Sundays, deleting…
user3812887
  • 439
  • 12
  • 33
0
votes
1 answer

How i can fetch data as unicode in Execute SQL TASK in SSIS

I have developing a project in SSIS. First I drag and drop a Execute SQL TASK in ControlFlow. After that I write a query in Execute SQL TASK like this : select 'رضا','خدائی' from dual And in Result Set I add two new variables, Fname and LName…
user2352554
  • 521
  • 4
  • 17
-1
votes
1 answer

How the result set of the following query in sql task can be assigned to a variable in ssis

Even after the below configuration , im not able to assign a query result to a variable
NAGARAJA H I
  • 149
  • 3
  • 11
-2
votes
1 answer

Can we truncate data in a Excel sheet using Execute Sql task?

I have a SSIS package in which Data is loaded from Sql server to Excel sheet. Now, whenever I run the package data got loaded with the previous loaded data. Requirement is to load only the fresh data and remove the existing data from excel…
Vishal Mishr
  • 195
  • 1
  • 8
1 2 3 4
5