Hi all, i developed a package which logs some data in Textfile everytime i run the package. everthing works fine, but i want a new text file created for every time i run my package. present situation is when i run my package for 2nd time it overrites the data with in the same text file, if i remove the check "donot overwrite" it will write in the same txt file. but i want a new text file created (also handle time stamp attahced to the text file so it will make textfile unique for the day) any help is really apriciated

Hi, this is easy to do if you create a dynamic flat file destination file name implemented through a package variable that is SSIS expression driven. Example: Dynamic Flat File Connections in SQL Server Integration Services SSIS http://www.mssqltips.com/tip.asp?tip=1084Arthur My Blog

okay i tried that before. i was actually missing to include the complete timestamp to the textfile, so it will differnetiate every time it runs and creates new faltfile. but thanks arthurZ.