October 11, 2005 at 12:04 pm
Hi All
I have a DTS package whcih transfors the record from one table on a server to a different table on the other server.
Lets say it transfers the data from Table A on server1 to table B on seerver2.
I have scheduled this package and it runs everyday at *:00 in the morning and moves all the records for the previous day to the other server table.
Now the problem is that few times in sysjobhistory it shows that the execution happened successfully but still the data is not moved to the Table B on server2..Why is it so??How can I trace this out as to why this is happening...
October 11, 2005 at 12:16 pm
I usually have the SQL Agent job create a log text file... It's often quite helpful in troubleshooting.
Job -> Steps -> Edit -> Advanced then specify a name & path in the "output file" area.
October 11, 2005 at 2:28 pm
I do that as well as enable logging in the DTS package itself on the "logging" tab of package properties.
Greg
Greg
October 14, 2005 at 12:39 pm
Is there a process that could be running at the same time on Server B causing the package to only work intermittenly? I would check your database connections as well.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply