import text file to SQL Server DB via DTS
I'm looking for a way to import a delimited text file from an FTP directory to a temporary SQL server table. I can only find a way to import text to DB from local directory structure. I'd like to set this up as a recurring package in DTS. Can anyone tell me the steps necessary to make this happen?
Many thanks - Paul