yes. i have changed that. i am using this instead in the assignment. use a transform to construct SQLInsertmsg with some dummy values.
sending the actual flat file records to a location. after all this, i am getting No subscribers found. there is a send port for sql insert.
strFileNameWPath = FDGLTransactMsg(FILE.ReceivedFileName);
strFileName = System.IO.Path.GetFileName(strFileNameWPath);
FilecreatedDate = FDGLTransactMsg(FILE.FileCreationTime);
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='Filename' and namespace-uri()='schemas.microsoft.com/…/dbo&]")=strFileName;
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToGLUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='DateCreated' and namespace-uri()='schemas.microsoft.com/…/dbo&]") = FilecreatedDate;
xpath(SQLInsertMsg,"/*[local-name()='usp_InsertFileNameToGLUpload' and namespace-uri()='schemas.microsoft.com/…/dbo&]/*[local-name()='matchCount' and namespace-uri()='schemas.microsoft.com/…/dbo&]") = true;