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.
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.
You cannot change it there. The value is fixed. You can change it on the output side. As simple as that.