Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
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 April 28th, 2006, 03:38 PM
Registered User
 
Join Date: Apr 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default DTS FTP Task file disappears after transfer

a co-worker and I have been having a similar issue in two completely different packages. We have dts packages put together that have an FTP task inside. When the package runs, the file does not seem to transfer. After further investigation, we both noticed that the file does seem to come over and then is gone after the transfer is complete. having the destination folder open while the task is running, the file starts to be created, but after the task completes the download the file just vanishes.

After a little bit of research I hear that this was a common problem prior to service pack 1. Just today one of the IT people installed SP3 locally on my machine (it has long been on the server itself) but I am still having the same problem.

Can anyone please help with this problem, I really just do not know where else to look!!!!!!

Thanks in advance!






Similar Threads
Thread Thread Starter Forum Replies Last Post
Secured FTP File Transfer syed_sooraj Classic ASP Basics 1 December 7th, 2007 06:29 PM
File System & FTP Task Granted BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 1 February 24th, 2006 06:02 PM
file transfer ftp server to a pocket PC in C# .NET g_hristodol ADO.NET 0 October 21st, 2004 06:14 AM
Task Bar Disappears NRT Beginning VB 6 0 October 20th, 2003 01:54 PM





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