Loading XML data into SQL Server 2008


7) Once the package has successfully executed you can see the tasks turning green and it will also mention the number of records transformed and published to SQL Server.



8) The sample XML data file used in this example is shown in the following image:



9) The data which was loaded into the SQL Server Table by the SSIS package is shown below:



10) Save the SSIS package by pressing CTRL  + S

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |