We have a new community! Please visit support.timextender.com

Error: "Incorrect syntax near ‘)’" when deploying SSIS package for AX Adapter with multiple environments

Note:  This is an old article, citing an issue with legacy systems or providers. Some troubleshooting tips may still be applicable to newer versions.  However, this article has not been tested with newer releases after 2016.


Everything deploys well in Development environment.
You moved the project from Development environment to Production.
Some tables deploy with no problem
A table with a Virtual Data AreaID reference fails on deploy SSIS package – failed. Incorrect syntax near ‘)’.


The problem is that there is a virtual reference on the table and that it has not yet been synchronized with the Dynamics AX data source, so it does not have the table for the virtual data. 


Synchronize the datasource to resolved the issue. 


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.