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:
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:
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:
FES_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.