title: importing data from files on an ftp server directly into sql server
body: <p>Is it possible to import files from an ftp server directly into a sql server 2008 table using perhaps an SSIS package or something? I have thought of transferring the files via ftp to a local server and then doing the import but just wondered if there was more economical way of doing this with regards to space and memory.</p>