Re: SQL Adapter passes all stored procedure parameters as nvarchar

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter passes all stored procedure parameters as nvarchar › Re: SQL Adapter passes all stored procedure parameters as nvarchar

February 5, 2007 at 7:46 AM #17559
community-content

    I have tried updating the date types in the xsd.  But I still get the error back from the SQL Adapter "cannot convert type 'nvarchar' to money" or whatever the data type I am trying to conver to.  When I look at what is happening using the SQL Profiler, all stored procedure parameters are sent as nvarchar.