Hi folks, I have a SSIS with Logging to Textfile. The Connection Manager is set to: UsageType = Create file I expected, that the Loggingfile was created with every start but all logged evants are appended. Can this be a permission issue? Is it possible, that the Proxxy account can write in an existing file but not creating a new one if it exists? If not exists, it is created. Is there any workaround because the files become too large.

If the file is NOT there, SSIS Log will CREATE one. If it is there, it will use it. What I do for my SSIS Text file logging is to add an Expression to the Connection String property of the text file connection manager that includes the following elements in the file name: Server, package name, and date. All the log files go in one folder and I can tell at a glance what package the log is for, when it was created, and by what server. My Expression is @[User::Logging_Folder] + @[System::MachineName] + " " + @[System::PackageName] + " " + (DT_STR, 8, 1252) ( YEAR(GETDATE()) * 10000 + MONTH( GETDATE() ) * 100 + DAY(GETDATE())) + ".txt"Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Hi guys, I didn't think about creating a new file with date because I was shure, it would be created new on every run. It's a proper way to do this. Sometimes I didn't see the wood for the trees ;-) Thanks a lot