question

balanarasimhac-1495 avatar image
0 Votes"
balanarasimhac-1495 asked ZoeHui-MSFT commented

Create,Load and drop table in SSIS

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @balanarasimhac-1495,

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.

110882-screenshot-2021-07-01-141454.jpg


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



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

May I know how's the issue going on now? If you have any updates, don't forget to tell us.

0 Votes 0 ·