Hello, I am trying to accomplish the exact same thing. I have created a variable called Path and on the connection for my flat file I have changed the ConnectionString Expression to be:
@[User::Path] + "Holdings_" + (DT_STR,4,1252) DatePart("yyyy",getdate()) + Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"
However I am not getting the path, all I get is Holdings_20080227.csv. This file is on a mapped drive on my server and so it should be saving to that shared drive.
Is it possible to just hard code the path?
Thanks
Greg