Re: DTSFTPTask

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 02/07/05


Date: Mon, 7 Feb 2005 19:09:49 +0000

In message <0122612F-102F-47EF-A045-93E21FB0EB5B@microsoft.com>,
codputer <codputer@discussions.microsoft.com> writes
>Thanks Darren for your reply...It does seem to work much more reliably. I
>did try to use your control, but it too could not seem to connect. In
>addition, I got to pull files from various directories...so in the end, I
>went back to the script.
>
>I know that DTS is rewritten in 2005 - is this piece any better? Have you
>played with it?
>

Well it supports both upload and download, and has a couple of extra
options compared to SQL 2000, but it is not everything to all people no
doubt. The overall architecture does make it quite easy to do dynamic
stuff with tasks, setting task properties and such like is more
flexible, and powerful. To be honest you may be better with something
like webdrive.

I haven't had any issues with it, but then I never had issues with the
existing tasks, mine or MS, when it came to reliability.

Cheers

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org


Relevant Pages

  • Re: Among available RDBMS. When to use ...
    ... While comparing MS SQL Server, Oracle and DB2, an author writes in a ... Reliability: Very reliable ... Managebility: difficult. ... RDBMS to use and in what situation, ...
    (comp.databases)
  • Among available RDBMS. When to use ...
    ... At present RDBMS industry has matured a lot and the big ... While comparing MS SQL Server, Oracle and DB2, an author writes in a ... Reliability: Very reliable ... Managebility: difficult. ...
    (comp.databases)
  • Re: SQL Servers and mySQLs
    ... "Jacky Luk" wrote in message ... > It is very embarrassing ... ... > and SQL Server 2000 in terms of performance, ... > reliability etc can anyone know of a list of ...
    (microsoft.public.vc.language)
  • Re: Monitoring replication from subscriber
    ... have a look on my site for a script to find pending merge changes. ... some discussion about the reliability of the data in it, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Testing and OO was Re: Is it possible to use the value of the PROGRAM ID within the source code?
    ... >>same rigorous testing that were the earlier standards, ... Given that testing in all too many shops is less than adequate now, ... User changes to control tables used in packages can have ... Managing change and verification of reliability has not been given ...
    (comp.lang.cobol)