SQL Server DTS Questions

1

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 [...]

Answer Question   |  April 20, 2009  7:08 AM
Crystal Reports, Data Transformation Services, iSeries Access, iSeries connectivity, iSeries interoperability, ODBC, Open Database Connectivity, SQL Server DTS
asked by:
40 pts.

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?

Answer Question   |  February 4, 2009  6:40 PM
DTS, DTS packages, SQL Server DTS
2,585 pts.

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 immediately it is executing so . What is the problem here .Any suggestions .

Answer Question   |  October 29, 2008  11:55 PM
Data Transformation Services, DTS packages, SQL Server DTS
asked by:
25 pts.

1