dynamically rename file name in ssis
Set up a Variable called DestinationFileName and use an Expression to evaluate it. build the expression using all the pieces you need. Then use that varialbe in the File System Task as the DestinationVariableTodd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
November 18th, 2010 4:02pm