Load Daily data into Temp Table or View

Question

Dear Experts, My SSIS package creates a table daily. (TableName_Feb_27_2021_1104PM_Import). I want to store this table data in a View or temp table. Let's say tomorrow if I get the table name (TableName_Feb_28_2021_1104PM_Import). Then I need to truncate the View or temp table and load the Feb28th data

Answer 1

Hi @San

Then I need to truncate the View or temp table and load the Feb28th data。

In my opinion, this is redundant. Why not just query data from the TableName_Feb_28_2021_1104PM_Import table?

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

A temp table gets automatically droped as soon the connection close and a view is "only" a prfined query, it can't store data. Why not using one, fix table e.g. with the timestamp of the data load?