python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
SSIS Execute SQL Task continue execution after completion of Oracle stored procedure
I have an Oracle stored procedure I am trying to execute in SSIS Execute SQL Task. This stored procedure involves refreshing materialized views. For each and every step completion we are logging it in...
PK1128
Votes: 0
Answers: 1
How get previous day in parameter in SSIS package
I have a package in SSIS when I have a start date with a parameter:
However I have a query then use that parameter, but I need to have de previous day here:
for exemple if start_date is '2022-03-03'...
Ricardo Ferreira
Votes: 0
Answers: 1
Rename table in SQL Server
I want to rename a table. But I get an error when running the code. What is the correct code?
DECLARE @TABLE_NAME VARCHAR(100)
SET @TABLE_NAME = 'Employee_Destination'
IF EXISTS (SELECT NAME FROM SY...
Insan Cahya
Votes: 0
Answers: 0
SQL Server Integration Package Conversion Error only when calling from job, not when executing in SQL Server Data Tools
Maybe somebody can provide assistance for the following question:
I have a SSIS package with Target SQL Server Version 2014. I am not 100% sure which version my target server is running, but it is at ...
Monty Burns
Votes: 0
Answers: 1