DTS Log detail with Run Status 0

		Wrox Programmer Forums > SQL Server > SQL Server DTS
DTS Log detail with Run Status 0

SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 3rd, 2006, 11:18 AM

Nicos

Registered User

Join Date: Mar 2006

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

DTS Log detail with Run Status 0

Hi Guys, I got a problem that I created a DTS package, There is a Sql query takes 2 hours to finish. But sometimes, it stopped without any reason and it blocked the total EXECUTION of DTS. It works 1 day over 2 days. I saw the log, the Run Status is 0, it has a start time but no end time.
Somebody has an idea with this. Thank you very much for your help.
Nicos.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DTS package - passing values at run time	kkrish	SQL Server 2000	1	June 20th, 2006 04:56 PM
Run DTS from ASP	rweide	Classic ASP Databases	2	January 18th, 2005 01:14 PM
AppException Class -Log Error to Event Log	bekim	BOOK: ASP.NET Website Programming Problem-Design-Solution	7	December 7th, 2004 01:01 PM
Problem to run delete and exec DTS in Stored Proc	tyh79	SQL Server DTS	7	July 14th, 2004 10:27 AM
RUN DTS from Stored Procedure	AyatKh	SQL Server DTS	2	April 11th, 2004 11:44 AM