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 |
|
eric_ht
Starting Member
37 Posts |
 Posted - 2007-08-23 : 10:32:53
|
| I have a package that runs everynight. One sql task in that package runs a stored proc that truncates a table then inserts into it. The problem is when this proc runs inside DTS it will not populate the file. I can run the proc in QA, let it populate the file first. Then from then on out when the proc runs inside DTS it will work correctly. But the first time the file needs populating, it will not happen inside DTS. This is a scheduled job also if that helps any.Am I completely crazy or is there something that could cause this? |
|
|
|
|
|
DTS will Not Populate File