Re: passing sql stored proc param type of bit

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › passing sql stored proc param type of bit › Re: passing sql stored proc param type of bit

July 10, 2014 at 11:20 AM #26404
community-content

    I strongly believe that the Stored Procedure is failing because of the datetime format issue for the RunToDate field.

    Just check the format of the Datetime column.

    Try to call the Stored procedure with the same parameters from SQL mgmt Studio. Once you get the right format….use a script functoid to convert your datetime to correct format and map it to the RunToDate element.

    The map seems to be working fine…as you do get the XML for the mapped Stored Procedure.