locked
How to do dynamic schema mapping or automate the process. RRS feed

  • Question

  • HI folks

    I have a sceniorr in my env 

           Source ADLS GEN2                ADF                         Sink sql database.

            csv 1                     

           

            csv 2                             COPY ACTIVITY                 Azuresql 

             .

             .

            csv n 

    Question is that my client is only once data in the form of multiple csvs suppose 100 csv. and I will prepare the schema and tables in azure sql , but coming to copy acitivity I need to use only one copy acitivty not 100. I read about pramersied query in adf but again it is not the proper way to automate it. problem came every time I need to manually change the schema mapping how can I do this process fully automate since data is given once only so no incremental is required. just simpel 100 csv need to copy in 100 tables but only using one copy block..

    Please share throught process on above scenioro.

    Thanks and Regards

    Anuj gupta

    Tuesday, January 21, 2020 7:43 AM

All replies