Its very strange. Its gone to about 3 different places. Almost like the last folder I was looking at when I was working on a different project.

I realised I needed to go to the flat file connection properties and expressions. For the connection String property it was set to just @[User::DFES_NAME_DATE_File_Name]+".csv"

So basically the file name with no folder attached.

I tried to change this to

"\\D-fs11\\spar-it\PROJECTS\\1 Active Projects\\DATA WAREHOUSING PROJECT\\Development\Extract_To_CSV\\"+@[User::DFES_NAME_DATE_File_Name]+".csv"

And was told that the token [Square bracket symbol] was not recognised. So I took that to mean the spaces in the folder names. I tried replacing them but nothing helped.

I then tried using another variable as the folder name so used the variable @Folder_Name which was already set with the actual folder name. This seemed to be good but when I ran it, the file names were created with [User::DFES_NAME_DATE_File_Name] twice but the first one was the same one every time and the second one was looped so this completely lost me.

So as yet I havent sorted it and worse Ive spent nearly all day trying to figure it out which is a massive waste of time on such a small thing. :crazy: