SQL - Export data from multiple views to multiple CSV files

Hi Guys,
I need help to export data from multpile views to CSV files one to one.
Either by T-SQL or a SSIS package.
I have tried using T-SQL like this:

SET NOCOUNT ON;
DECLARE @Views as TABLE (Object_id int, name nvarchar(200));

INSERT INTO @Views (Object_ID, name)
SELECT      Object_ID, name 
FROM        sys.views
WHERE name LIKE 'VW_XFormData_%'

DECLARE @viewName   nvarchar(200) = (select top 1 name from @Views);
DECLARE @sql        nvarchar(max) = '';

WHILE(Exists(select 1 from @Views)) BEGIN
	SET @sql = 'EXEC xp_cmdshell ''SQLCMD -S . -d EPIServerColoplastCMS -Q "SELECT forms.*, vw.* FROM ' + @ViewName + ' vw INNER JOIN VW_XForms forms ON vw.Meta_FormId = forms.ExternalId" -s "," -o "D:\CSV\' + @ViewName + '.csv"'';'
	EXEC(@sql); 
    --Print (@sql);

    DELETE FROM @Views where name = @viewName;
    SET @ViewName = (select top 1 name from @Views);
END;

Select allOpen in new window

Above works but the CSV files look like crap (a lot of spaces and line shifts), so it's not usable.

If have better ideas how to export data to CSV files either by using T-SQL or articles describing how to create a SSIS package doing the same wouold be great.

Thanks