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

Govarthanan Venkatesan 66 Reputation points
2022-03-23T11:17:10.253+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,891 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 33,551 Reputation points
    2022-03-24T02:55:31.53+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful