Debbie Edwards (2/21/2013)
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.
I don't think so. Could it be that single backslash characters are causing an issue? (You may need to double them up.)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.