ssis - excel generate problem (generate with template excel)

Question

i am using a template to generate excel. (the template just contain column header)

if i have 2 same structure table with 3 column.

table A with col_1 nvarchar(100), col_2 nvarchar(100), col_3 nvarchar(100)
table B with col_1 nvarchar(100), col_2 nvarchar(100), col_3 nvarchar(100)

my export excel sql in source:

select a.col_1,a.col_2,a.col_3 from table_A inner job table_B on a.col_1=b.col_1 where (a.col_2<>b.col_2) or (a.col_3<>b.col_3);

if data in table A same as table_B, it will not generate a excel.

how can i make still generate excel even 2 table is equalivent. (blank excel only with the template header)

Answer 1

Hi @nononame2021 ,

how can i make still generate excel even 2 table is equalivent. (blank excel only with the template header)

If the two tables are equivalent, what data do you want to export? TableA?

Here is a tutorial about how to compare tables and then use conditional split to do data offloading.

SSIS Tutorial - Table Compare

Hope it could give you some ideas.

Regards，

Zoe

---

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.