FTP Task - Using the File Transfer Protocol Task to Download and Upload Files - Video Series Video Category: Working with the Common Tasks in DTS Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2000 You need to download a file from a remote server and load the data into your SQL Server, right? Seems simple enough - people do it every day, right? The FTP Task can simplify, to a certain degree, your life. Watch this series of videos for an in-depth look at using the FT task in lots of common data movement scenarios.

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to the FTP Task (the File Transfer Protocol Task) and Ho...     200 13 mins. Download Pt. 2 - Using the FTP Task in Your DTS Packages   200 13 mins. Download Pt. 3 - Working with Variables as File Names and Assigning File Names at Runtime   300 15 mins. Download Pt. 4 - Assigning File Names at Runtime Using VBScript and the ActiveX Scripting...   300 9 mins. Download Pt. 5 - Working With Multiple Files and Using a Table to Store Processing Info   400 9 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Book You Should Probably Own: Ken England's "Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" Helpful Keyboard Shortcuts: "Windows key" + "D" shows the desktop Tracert ("trace route") is a great command-line tool that you can use to trace the path that an Internet Protocol (IP) packet takes from the source to the destination. Tracert is a great tool for determining if a hub/router/switch is down or having problems