Dynamic Column Mapping in OLE DB Destination for CDC Implementation Using Metadata Driven Approach in ssis

Question

In CDC Implementation,

I need to map the CDC Splitter output to OLE DB Destination but we want to map with the columns from the meta data table as dynamic.

I've tried with variable approach using stored procedure, but it didn't work out.

Please help me on this.

Answer 1

Hi @Govarthanan Venkatesan ,

I'm not familiar with CDC Implementation.

As far as I known, to do Dynamic Column Mapping in SSIS.

Most resolution is use Script Component.

Check these links to see if it could give you some ideas.

How to Map Input and Output Columns dynamically in SSIS

How to manage SSIS script component output columns and its properties programmatically

ssis-dynamic-column-mappings

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.