I am trying to upload a .csv to an FTP site. The customer requires the file have an extention of yyyymmddhhmm and they do not want the header information. I had origially set it up as a file script with results. i was able to upload the file with the proper extention, but there is no way that i can find to elimanate the header information. If i use the to Export wizzard, I can control the header, but i can not control the format of the date suffix. it allows me to add it, but not control the format. Any ideas?
For the extension, they will need to build their own suffix. Use the Copy File activity and build formatted current_date like the below image. The best we can do is the format string he wants but all upper case.
That works until you try to upload to the FTP site. What file do I define? The file name will change every day, but the FTP definition wants you to select a file name.
I ran your post past Debbie Peabody our automation expert and she suggest the following:
In automation, they would have to do this in two parts. First use the export wizard and uncheck the use headers option. See below image:
For the extension, they will need to build their own suffix. Use the Copy File activity and build formatted current_date like the below image. The best we can do is the format string he wants but all upper case.
