SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,568 questions
How to develop a package for creating a table, loading data from source document and drop table again?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ramana Kopparapu
306
Reputation points
Hi all,
Hope you are doing well.
Data getting from Source docs regularly.
First need to create table
Load the data from Flat File Source
Drop the Table Finally....
Can anyone tell how to design the SSIS package with above logic?
{count} votes
-
ZoeHui-MSFT 36,116 Reputation points2024-09-12T05:35:41.22+00:00 Hi @Ramana Kopparapu，
Load the flat file source data to table and then drop the table? Are you sure? Seems you are do nothing about the data and the table.
Sign in to comment
Sign in to answer