ssis - excel generate problem (generate with template excel)

nononame2021 246 Reputation points
2022-06-29T09:41:31.013+00:00

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)

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2022-06-30T03:17:26.227+00:00

    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.

    No comments

0 additional answers

Sort by: Most helpful