Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by gpatton
-
Trying to schedule a DTS with ODBC connection
The most detail the SQL Server Agent Job History gives me is this: The step did not generate any output. Process Exit Code 0. The step succeeded. I am batching the records 1000 at a time. Profiler just indicates it inserted 1000 rows, then another 1000 etc. It then just stops. No more...- gpatton
- Post #6
- Forum: Microsoft SQL Server: Programming
-
Trying to schedule a DTS with ODBC connection
It leaves no messages in any of the logs (Win 2000 event logs, SQLAgent, DTS). It appears as far as SQLAgent is concerned, as long at it kicks off the DTSRUN statement, it is successful because SQLagent always indicates job success. The DTSRUN.exe process just stops. I have to go into task...- gpatton
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Trying to schedule a DTS with ODBC connection
Has anyone had any luck with this issue? I am using DTS in SQL Server 2000 to pull data from our AS/400 using IBM's client Access ODBC driver. If I execute the package manually (even if I am actually on the server itself) it works perfectly. As soon as I try to schedule it with SQLAGent, it...- gpatton
- Post #2
- Forum: Microsoft SQL Server: Programming
