Forum Discussion

SABSLI's avatar
SABSLI
Copper Contributor
May 26, 2020

transform data (ssis)

Hello  I work on a client project which consists in monitoring the time allocations of the employees. a file is extracted from the platform which allows the entry of times but this file does not app...
Business Intelligence
Integration Services
SABSLI's avatar
SABSLI
Copper Contributor
May 28, 2020

HI bake13 

Thank you for your answer

i am using sql server 2017 standard edition 

effectively there is 3 persons on the file 

i've added in this msg the result that i want obtain (tab= result)

thanks

best regards

bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jun 03, 2020

Hi SABSLI --  Apologies for the delay.  I think this can be accomplished using either a derived column or conditional split or some combination of the two.  This might be a bit challenging given the structure of the source data.

 

As soon as time permits, I will try to create an example package.

  • Simple_Balayeur's avatar
    Simple_Balayeur
    Brass Contributor
    Jun 05, 2020

    Hi and good day:)

     

    1)When I first read the original post: I saw some 'confusion' which you where helped for.

    2)When I read the last post about derived column it made sense

    3)Still there is a 2% chance of error.

    4)Maybe you should reformulate question with new data points (2)

     

    Have a great day

  • SABSLI's avatar
    SABSLI
    Copper Contributor
    Jun 04, 2020

    HI bake13 

     

    Thank you very much for your help

     

    best regards

     

     

Resources