I need to insert an xml file data into a SQL Server database table using Cold Fusion 11.
I have an SSIS package on the SQL Server that inserts the data.
Is there a way to execute the SSIS package in Cold Fusion?
Is there a SQL statement to insert the data with out using the SSIS package in Cold Fusion?
Thanks in advance,
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.
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 !!