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

This post has been republished via RSS; it originally appeared at: SQL Server Support articles.

First published on MSDN on May 14, 2018


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.
  
  
  
  • SQLServer 2012
  
  
  • SQLServer 2014
  
  
  • SQLServer 2016
  
  
  
  


• 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