FTP + SQL2000 DTS – excellent!
For all of us dinosaurs still using SQL 2000, an extremely useful (if you need this of course!) custom DTS task is the SQLDTS FTP Task which “is designed to give you greater control over FTP operations compared to the task supplied with SQL Server 2000″. The ability to FTP text files (in both directions) lends itself to greater use of DTS for common text processing tasks, which can only be a good thing, but whether it does or not, if you need greater flexibility with FTP in your existing DTS processes it’s extremely useful (and works perfectly from what I can tell).
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Leave a comment