HI Team,
How to create table, load data into table and drop same in single SSIS package
Table Creation --> 2. Data Load to Created Table --> 3. Drop table which created in 1
Please help on this
HI Team,
How to create table, load data into table and drop same in single SSIS package
Table Creation --> 2. Data Load to Created Table --> 3. Drop table which created in 1
Please help on this
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
May I know how's the issue going on now? If you have any updates, don't forget to tell us.
6 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh