Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax

CREATE PROC prMusicCollectionXML
AS
DECLARE @XmlOutput xml
SET @XmlOutput = (SELECT ArtistName,AlbumName,YearReleased FROM Album
join Artist ON Album.ArtistID = Artist.ArtistID
FOR XML AUTO, ROOT('MusicCollection'), ELEMENTS)

SELECT @XmlOutput
go