SQL Server DTS

ODBC Connection to iSeries

Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a...

Troubleshooting a DTS job failure on SQL Server

I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

DTS

Posted - 10/28/2008 : 18:52:31 -------------------------------------------------------------------------------- I am trying to schedule a DTS package . But its says nothing, no error displays and finally it does not execute and hence a job is not created . But when I execute it...