Dynamic file names

More
10 years 6 months ago - 10 years 6 months ago #6855 by hanisultan
I'm using {GetSystemDate('YYYYMMDD')} within the file name so I can have the date as part of the file name when I create it. This is working perfectly in a transformation I developed which creates a file with today's date as the name. Now in my package which calls this transformation, then ftp the file created to some ftp site. My problem is using {GetSystemDate('YYYYMMDD')} in the ftp object to find the file and ftp it but that doesn't work. The ftp object can't find the file, it actually add {GetSystemDate('YYYYMMDD')} as a string and trys to look for a file that has a name with {GetSystemDate('YYYYMMDD')} being part of it. See attached. What should I do to fix this? thank you

ETl Entr v 5.6.3.12

Ok I tried adding a script to create the file name to this package hoping it would work but no luck see attachment. The FTP package isn't replacing the variable with its value .. see log
Last edit: 10 years 6 months ago by hanisultan. Reason: Add another object to the package

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #6863 by hanisultan
Replied by hanisultan on topic Re: Dynamic file names
Any luck with this one? Please help

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #6871 by admin
Replied by admin on topic Re: Dynamic file names
Can you try latest version please

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #6873 by hanisultan
Replied by hanisultan on topic Re: Dynamic file names
I have installed the latest Version and it worked. You guys Rock

Please Log in or Create an account to join the conversation.