Upload XML File

To upload an XML file into SQL Server 2008:

1. Open SQL Server Business Intelligence Studio.
2. Create a new package ( shown in previous post)
3. Create Destination table on Server to upload file to.
4. Drag on Execute SQL Task - add TSQL to truncate the table.
5. Drag on Data Flow Task and double click
6. Drag on XML Source file and set the properties.
7. Drag on OLE DB Destination and set properties.

Job Done.