I have xsd schema. I had 2 problems that I needed to fix. 1. guid type I needed to change to string and 2. ErrorCode column that I had in xsd schema gave me duplicate error in SSIS and I renamed it. Now I am executing data flow and it runs sucessfully but 0 rows in the end of it and my XML has data in it. I do not get any error messages just this info. I am also trying to debug but it does not even open grid for debugging. What is it? Why I do not get any data back from it? Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "OrderIds" (104923) on output "ShippingOrderDetail" (18903) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Output_Id" (104926) on output "ShippingOrderDetail" (18903) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Copy of Guid" (105060) on output "Data Conversion Output" (53499) and component "Data Conversion" (53497) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Output_Id" (105041) on output "Output" (19184) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Result_Id" (105044) on output "Output" (19184) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Result_Id" (105053) on output "Result" (19200) and component "XML Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning. Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning. Information: 0x402090DF at Data Flow Task, OLE DB Destination [105064]: The final commit for the data insertion in "component "OLE DB Destination" (105064)" has started. Information: 0x402090E0 at Data Flow Task, OLE DB Destination [105064]: The final commit for the data insertion in "component "OLE DB Destination" (105064)" has ended. Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning. Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "OLE DB Destination" (105064)" wrote 0 rows. Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning. SSIS package "Package.dtsx" finished: Success. V. A.

Hi, seems to me your mapping was not done, please review. To convert data types use data conversion step.Arthur

mapping is done fine and conversion also done. Why I am not getting any errors? Can it be problem with xsd schema because I did manual changes to it?V. A.

the execution result that you have shared does not show any problem. Well with XSD you have and the xml data file you have can you do a Preview and see whether you see the data.vinu

the log you posted here contains no error, these are just warnings, and I think package executed successfully. could you tell us more in details why you think package don't work successfully?http://www.rad.pasfu.com

Hello, We may insert XML data through .Net application into the database via the usage of stored procedure. The whole program has been illustrated in the best way in this link. You may visit it... http://www.visiontechno.net/studymats/xmlinsertion.html