Search code examples
ssisoledboledbcommand

SSIS OLEDB Command DataType error


I am not able to change the Data type of a parameter in the advanced editor options of OLEDB Command transformation. Every time I change it, upon reopening the Advanced Editor, the change is reverted.

See the screenshot

Here, if I change the data type from string [DT_STR] to Unicode string [DT_WSTR], upon reopening it is changed back to string [DT_STR] again. Is there any way to make change the data type value here? Thanks in advance.


Solution

  • You cannot change it there. The value is fixed. You can change it on the output side. As simple as that.