S4 Tables vs sql server table

Question

Hello Team,

I am having S4 Tables and extracting the data and loading into SQL Server DB Tables.

In S4 : Table1 we are having 130 Columns and we trying to extract only 110 columns in SQL Server table1.
Similar way there are more than 50 tables and have the same issue and I am using single pipeline with lookup table list. How we can overcome this issue.

Please advise.

Regards
RK

Answer 1

Hi @Rohit Kulkarni ,

Thank you for posting query in Microsoft Q&A Platform.

You can achieve this my having only required columns mapped under mappings tab inside Copy activity.

But, If you are going to use same copy activity for different files with different schemas, then these mappings should be dynamic. Please check below video where how to dynamically map columns discussed.
https://www.youtube.com/watch?v=b27gmOufge4

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators