Excellent piece and its helped me figure out my problem with adding the files to a folder.
My problem is that my folders arent on the C drive but they are in a specific folder.... e.g.
And when I add this to the connection string like it says in the documentation
"C:\\DataFiles\\" + @[User::JobTitle] + ".csv"
But this instead.....
\\D-fs11\example-it\PROJECTS\DATA WAREHOUSING\Extract_To_CSV+@[User::CODE_NAME_DATE_File_Name]+".csv"
I get an error message
Attempt to parse the expression failed. The toke "\" at line number 0 was not recognised. Im beginning to think that you have to add all the folders for this to the C Drive only.