I am having a difficult time with having this workflow rename the file.
It keeps creating 2 files and 1 file has the data, but doesnt have the name (wanting to add date to end of name).
Any ideas on how I can stop it from creating 2 files? This was the only way I could think of to get the dates pulled in to rename the file.
Solved! Go to Solution.
@jonathangonzales I think you would want to use an append with the Data Mart being the Target (T) and the Date being the Source (S). I'm assuming your date table has just one column with one row that should be added to every row for your data mart.
Let me know I'm missing something.