FTP Directly into SQL Server

Hello,
Is there any way to FTP files directly into SQL Server?
We'll have users who want to FTP a file to us. Instead of bringing it into a file system, we'd like it to automatically put the file into a field in a table.
Is there a product out there that sits on top of SQL Server that will take FTP requests directly, or is there something internal?
We would rather not have to write it to a file, then pull it into SQL server via some polling mechanism. We want the user's action to dictate the whole process.
Thanks in advance
In article <57F9D4E8-4E14-44F0-AFEA-03EDDAEBE945@.microsoft.com>,
sqlquestion0001@.discussions.microsoft.com says...
> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it
> into a file system, we'd like it to automatically put the file into a
> field in a table.
> Is there a product out there that sits on top of SQL Server that will
> take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL
> server via some polling mechanism. We want the user's action to
> dictate the whole process.
I would look at something like Mabry's FTP Server library and build the
app yourself. It's actually a very easy control to use and it will let
you enforce decent security. I would recommend running this app on a
different server as FTP requires a lot of ports to be open.
There are also a number of shareware FTP servers out there that let you
setup accounts and restrict file types. You can set fixed commands to
run on the upload completion event.
|||Why not just get them to use bcp to "send" it to you instead of FTP?

> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it into a file system, we'd like it to automatically put the file into a field in a table.
> Is there a product out there that sits on top of SQL Server that will take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL server via some polling mechanism. We want the user's action to dictate the whole process.
> Thanks in advance
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

FTP Directly into SQL Server

Hello,
Is there any way to FTP files directly into SQL Server?
We'll have users who want to FTP a file to us. Instead of bringing it into
a file system, we'd like it to automatically put the file into a field in a
table.
Is there a product out there that sits on top of SQL Server that will take F
TP requests directly, or is there something internal?
We would rather not have to write it to a file, then pull it into SQL server
via some polling mechanism. We want the user's action to dictate the whole
process.
Thanks in advanceIn article <57F9D4E8-4E14-44F0-AFEA-03EDDAEBE945@.microsoft.com>,
sqlquestion0001@.discussions.microsoft.com says...
> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it
> into a file system, we'd like it to automatically put the file into a
> field in a table.
> Is there a product out there that sits on top of SQL Server that will
> take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL
> server via some polling mechanism. We want the user's action to
> dictate the whole process.
I would look at something like Mabry's FTP Server library and build the
app yourself. It's actually a very easy control to use and it will let
you enforce decent security. I would recommend running this app on a
different server as FTP requires a lot of ports to be open.
There are also a number of shareware FTP servers out there that let you
setup accounts and restrict file types. You can set fixed commands to
run on the upload completion event.|||Why not just get them to use bcp to "send" it to you instead of FTP?

> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it int
o a file system, we'd like it to automatically put the file into a field in
a table.
> Is there a product out there that sits on top of SQL Server that will take
FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL serv
er via some polling mechanism. We want the user's action to dictate the who
le process.
> Thanks in advance
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faqsql