Hi All,

When I use WSI(DoItUsernamePwd) to Excute Sql, it convert the input parameter(XmlInputRequestString) to lowercase.

I am not executing any store procedure through this method instead I am executing following SQL statements:

<AspDotNetStorefrontImport> <Query Name='InsertProduct' RowName='Product'><SQL><![CDATA[ DECLARE @CODE VARCHAR(50)
SET @CODE = '00036_MOSSY_BRNCH_BRN'
DECLARE @NAME VARCHAR(50)
SET @NAME = 'Mossy Branch - 44" - Brown'
DECLARE @WEIGHT FLOAT
SET @WEIGHT = 0.5
DECLARE @PRICE FLOAT
SET @PRICE =4.27
DECLARE @DESCRIPTION VARCHAR(550)
SET @DESCRIPTION ='44" Mossy Branch'
DECLARE @ProductID INT
INSERT INTO Product(Name,Description,SKU,Published)
VALUES(@NAME,@DESCRIPTION,@CODE,1)
SET @ProductID = IDENT_CURRENT('Product')
IF @ProductID > 0 BEGIN
INSERT INTO ProductVariant(IsDefault,Name,Description,ProductI D,Price,Weight)
VALUES(1,@NAME,@DESCRIPTION,@ProductID,@PRICE,@WEI GHT)
END
SELECT @ProductID as ProductID
]]></SQL></Query></AspDotNetStorefrontImport>

Can any one please help?

Thanks,
Nick