This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 21%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
SSIS doesn't throw error for any implicit conversion in dataflow at compile time unless we execute it.
We have this column called DBAName in source which is Boolean, and target datatype is DT_STR (as you can see in the following two screenshots).
But if we execute it without converting DBAName to DT_STR explicitly, in throws an error.
Is this a known behavior?
What are general recommendations to avoid these types of issues where at compile time we don't see any warnings or errors but we get error at the runtime?
Use a Derived Column Transformation to convert numeric/boolean to string.
@Olaf Helper Yes we are using that already, just wanted to confirm this doesn't get casted / converted implicitly but needs explicit conversion, right?
Yes, SSIS don't convert implicit, it must be done explicit.
which we had to cast again to fix it.
Cast into what?
By definition of a boolean is
0 = false
Every other value = true
Hello @Olaf Helper
Sorry there was not enough details mentioned which I added now. This is regarding the need of explicit conversion, and if this is expected behavior or not (as boolean to string should get casted automatically).
Could you please re-check the description and advise accordingly.
Thanks for your quick reply.