View Single Post
  #1 (permalink)  
Old July 31st, 2003, 06:41 PM
pabloron pabloron is offline
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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