Zappysys XML destination is failing to handle boolean types

Introduction

Our XML destination has some issues related to the boolean. In this article, we will show a workaround to solve this problem.

Solution

We will need 2 variables. One is the boolean variable and the other is the XML text.

We will also use the ZappySys Logging task to create our own custom Dynamic Mapping:

 

Finally, use that variable in the file destination using an Expression.

The following tutorial will show you how to go to expressions:

https://zappysys.com/blog/ssis-dataflow-expression-source-component-property/

In the expressions, set the [XML File Destination].[layoutinfo] property to use the XML variable filled with the logging task.

And that is all! Thanks a lot for reading this small article.