I don't think you can execute an SSIS package from ColdFusion. Why can't you just execute the package from SSIS?
I need to validate the data sent into the application by inserting the data into a table and checking the information against another table.
The process would let the individuals know of any issues with the data sent.
Process XML data using OPENXML function
DECLARE @XML AS XML, @hDoc AS INT, @SQL NVARCHAR (MAX)
SELECT @XML = XMLData FROM XMLwithOpenXML
EXEC sp_xml_preparedocument @hDoc OUTPUT, @XML
SELECT CustomerID, CustomerName, Address
FROM OPENXML(@hDoc, 'ROOT/Customers/Customer')
CustomerID [varchar](50) '@CustomerID',
CustomerName [varchar](100) '@CustomerName',
Address [varchar](100) 'Address'
EXEC sp_xml_removedocument @hDoc
Learn more scenarios by learning SQl Server Course !!