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 |
|
im1dermike
Posting Yak Master
222 Posts |
 Posted - 2010-05-21 : 09:06:28
|
| I have a number of SSIS packages which move data between SQL Server views and tables. I've optimized them to use transaction logs. If I understand correctly, this entails creating a number of temp files to process the package. I believe the default directory for storing these temp files is C:\Documents and Settings\user\Local Settings\Temp.The problem I've come across recently is that the computer will either delete these files on a regular basis or clears the files so they're blank. If it deletes the files, the package will fail which I find out about when my process subsequently fails. This results in me having to recreate the package. On the other hand, if it just clears the temp files, the package finishes with a "Success" status. This creates more of a problem because it appears as if the package worked, but it actually accomplished nothing.How can I avoid this problem? |
|
|
|
|
|
SSIS package temp files being cleared