Wrox Programmer Forums
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
Old July 26th, 2005, 12:52 AM
Registered User
Join Date: Jul 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem in DTS

I'm facing a unique problem when executing a DTS package (residing on the server) to load ASCII file thru ASP. If there is no data error the file gets loaded and every thing is fine. If there is some data error in the file, the file is not loaded and an error message is generated. So far so good. Now if I try to delete or move this file I get an OS error

"Cannot delete/move file: It is being used by another person or program"..blah..blah

I have taken care to uninitialize the package and all the objects associated with it.

Any ideas anybody ????

Similar Threads
Thread Thread Starter Forum Replies Last Post
dts problem garg SQL Server DTS 7 October 2nd, 2006 03:20 PM
DTS Performance Problem abob SQL Server DTS 0 September 6th, 2005 04:06 AM
DTS Column Mapping Problem hortoristic SQL Server 2000 2 August 2nd, 2004 03:21 PM
DTS problem :( meemee SQL Server 2000 1 March 4th, 2004 06:49 AM
DTS Problem galaxy@net SQL Server DTS 0 January 7th, 2004 05:54 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.