Wednesday, April 16, 2008

Error: ...The failure may be cuased by the fact that under the default settings SQL Server does not allow remote connections

While deploying my BizTalk Project i received the following error

- Open the Properties of the project,
- Under Configuration properties, select Deployment
- Check if the server is correct

Friday, April 4, 2008

Replace " (double quotes) from Field Elements with Xslt

I receive a CSV file, all string values are surrounded by " (double quotes).
This is normal for a CSV file, to use with Excel. But when I need the values of these fields in my Xml to send to SharePoint, you can understand that I don't want to have those double quotes in the fields.

I didn't find in my map a functiod to Replace those double quotes

I created a map with a Custom Xlst, and used the function Translate for each field

I added this map to the receive port. Once the Xml file arrives in my Orchestration,the double quotes are gone.