Need help in FTP to SQL server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help in FTP to SQL server

Author

Topic

turbo
Starting Member

19 Posts

Posted - 2010-08-10 : 09:11:08

Hi , Need help in FTP (file transfer proto).

can u help me out in a SP which sends a file (.txt) to a sql server.
THanks in adv .

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-10 : 13:39:05

cant you use tool like SSIS for achieving this? Otherwise you need to use xp_cmdshell to achieve this
see

http://www.virtualobjectives.com.au/sqlserver/ftp_scripts.htm

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources