Freigeben über

Invalid Column __$command_id issue during CDC implementation in SSIS package

  • Artikel

 

In this blog, we will be addressing the problem with CDC implementation in SSIS package which goes with the error ‘invalid column name __$command_id’ .

 

CDC stands for the change data capture. It was introduced in SQL server 2012. In SSIS package we have CDC control flow task and CDC source and CDC destination in Data flow task. CDC processing logic split into two packages – an Initial Load package that will read all the data in the source table, and an Incremental Load package that will process change data on subsequent runs.

 

Issue:

While previewing the CDC source task in an incremental package load, we get the error: ‘invalid column name __$command_id’

 

 

 

Solution:

  1. Ensure we are on the latest the latest version of SQL server.
  1. If the issue persists,
  • Download the Attunity dlls from the following site based on your SQL Server/SSIS version.
  • Place the dlls in the right location and GAC
    • We can find 4 dll in $\bin on the downloaded folder:
      • Attunity.SqlServer.CDCControlTask.dll
      • Attunity.SqlServer.CDCDesign.dll
      • Attunity.SqlServer.CDCSplit.dll
      • Attunity.SqlServer.CDCSrc.dll
  • You need to replace each of them to:
    • X86 folder
    • X64 folder
  • Further GAC them so that they appear on the GAC_MSIL folder

 

 

Detailed locations are here:

 

 

Please reach-out to the SQL Server Integration services support team if you are still facing any issues

 

 

 

Author:       Chetan KT - Technical Advisor, SQL Server BI Developer team, Microsoft

Reviewer:   Krishnakumar Rukmangathan – Support Escalation Engineer, SQL Server BI Developer team, Microsoft