January 15, 2010 at 6:50 am
I'm running SQL Server 2000 and I have a single DTS package that seems to be cause me a bit of trouble. The package itself goes out and get data from a group of Visual Fox Pro DBF. and one at a time imports the contents of the DBFs into SQL server. I have this running on a schedule, but I have noticed that every now and then one table in particular will not be imported but the job does not fail either. The data is important and I need to import it every day. Any thoughts?
January 15, 2010 at 8:22 am
In the DTS package, is the precedence between steps set to success or completion? This would affect how the job status is reporting.
_____________________________________________________________________
- Nate
January 21, 2010 at 8:57 am
There is none, its just a simple task to get data from one source to the other.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply