I am creating the project using visual studio and its wizard, there the connections are possible.
Basically the application is about reading a XML file and sending the info to the SQL Server database. Hence, there is no orchestration project. there is receive and send port only. receive is for geting XML file and send port is for sending the info over to SQL.
Hence there is no schema as well. Orchestration is done through \”Add Generated Items\” in Visual Studio. The project doesnt need to be deployed as such. Hence HAT is not possible I guess.
[b:3426b5ed73]
The error I get on Event Logs is
The adapter \”SQL\” raised an error message. Details \”‘.’, hexadecimal value 0x00, is an invalid character. Line 2, position 1.\”.
I saw the XML, it has a dot \”.\” before every character. I don’t know how to solve it.[/b:3426b5ed73]