Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-08-22 : 01:04:56
|
| Hi all,I am looping through xml files in a given folder using xslt xml task then load the information to a table in my databaseOn error I direct it to a flat file destination but it time it overwrites the error message file I want it to append to it.Also when I tried to name the file with a timestamp it created a lot of empty files with the specified timestamps.Thankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-22 : 01:19:36
|
| you've check box called overwrite data in file. you need to uncheck it for your flat file destination------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
append to an error text file