latingntlman (2/25/2013)
quick update:At this point I just need to append a date time stamp to the name of the file (i.e. FileName_YYYYMMdd_HHmmss.txt)
How can I accomplish this?
1. Set a string variable with an expression for the file name. The following is close but the date is not formatted to your specifications and will need a bit more work.
"FileName_" + (DT_WSTR, 50) (DT_DBTIMESTAMP)GetDate()
2. Set the connection string expression to the variable in the connection manager for the text file. Be sure the path to the file is included.