Share via

how to make empty(delete/truncate) table in oracle before inserting using SSIS

qasimidl 106 Reputation points
2023-07-25T12:05:21.77+00:00

Hi,

How can we delete/truncate oracle table before inserting data using SSIS.

Sql server 2017

Visual Studio 2022

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-07-27T02:12:54.7166667+00:00

    Hi @qasimidl，

    The Execute SQL task runs SQL statements or stored procedures from a package. The task can contain either a single SQL statement or multiple SQL statements that run sequentially. You can use the Execute SQL task to delete/truncate oracle table.

    Execute SQL Task

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

  2. Olaf Helper 47,436 Reputation points
    2023-07-27T05:41:31.48+00:00

    How can we delete/truncate oracle table before inserting data using SSIS.

    Why are you asking; sure you can? Just issue the SQL command; if the executing account do have permissions for.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.