Create,Load and drop table in SSIS

Question

HI Team,

How to create table, load data into table and drop same in single SSIS package

1. Table Creation --> 2. Data Load to Created Table --> 3. Drop table which created in 1

Please help on this

Answer 1

Hi @Bala Narasimha Challa ,

Table Creation/Drop table:

Use Execute SQL Task to configure the connection and the SQLStatement.

Using the create table code. If you want to drop table just use the code 'drop tablename' in the same way.

To load data you may use the OLE DB Destination.

load-data-by-using-the-ole-db-destination

There are also some blogs online you may take a reference.

https://www.mssqltips.com/sqlservertip/2826/how-to-create-and-use-temp-tables-in-ssis/

Regards，

Zoe

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October