SSIS: The parameter type for ‘@P1’ cannot be uniquely deduced; two possibilities are ‘sql_variant’ and ‘xml’

Recently, while working on SSIS we came across a situation to use parameters. We wanted to pass 2 parameters. We were using SQL Command as Data access mode in OLE DB Source Editor. After writing the query the below query: select ? from channelmaster where displaychannel=? When we clicked on parameters to provide the parameter … Continue reading SSIS: The parameter type for ‘@P1’ cannot be uniquely deduced; two possibilities are ‘sql_variant’ and ‘xml’