This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

while creating logging file how to get file name with current date and time

Question
0

Sign in to vote

while creating logging file how to get file name with current excution date and time should be in am or pm

Thursday, February 10, 2011 4:24 PM

Answers

0

Sign in to vote
SSIS Expression is the solution.

Example: http://consultingblogs.emc.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx
Arthur My Blog
- Proposed as answer by Todd C Thursday, February 10, 2011 4:34 PM
- Marked as answer by Jerry Nee Monday, February 21, 2011 1:45 AM
Thursday, February 10, 2011 4:27 PM