SQL Server Performance Forum – Threads Archive

FTP from TSQL?

I know that I could cmd_shell out and run the FTP command. Does anyone know how I could FTP in TSQL without using the cmd_shell? I have looked though Books Online and found a lot of stuff talking about DTS packages and how to FTP using DTS. I didn’t find anything about FTPing using TSQL. Live to Throw
Throw to Live

The only other way (without using the lame-o DTS ftp) is using sp_OA* procedures. I do not know if there is a FTP COM object though…

http://www.sqlservercentral.com/columnists/JTallamraju/data_import_functionality_using.asp
http://geekswithblogs.net/danwoolston/archive/2005/08/31/51784.aspx … links tohelp you with. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Is there any security level disadvantages when using cmd_shell? Madhivanan Failing to plan is Planning to fail

Check outhttp://www.sqlsecurity.com —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

A lot.. .how many you want[}<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] The extended stored procedure xp_cmdshell allows you to shell out and execute an valid operating system command. By default, all users allocated to the fixed system role sysadmin (ie. SA account) have execute access. SQL 2005 improvment: If you try to use xp_cmdshell, you may receive this: â€œMsg 15501, Level 16, State 1, Procedure xp_cmdshell, Line 1 This module has been marked OFF. Turn on ‘xp_cmdshell’ in order to be able to access the module.â€ Definitely, a step forward in making our SQL Server implementations more secure. So it appears in order to further their efforts in making their server products more secure, Microsoft has graciously turned off xp_cmdshell by default. Not a bad idea. If you never use it, then you#%92ve got a little bit of added security by default. And, I guess if you can figure out how to turn it on, then you know enough about Sql Server to know how to secure it too. <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Madhivanan Is there any security level disadvantages when using cmd_shell? Madhivanan Failing to plan is Planning to fail <hr height="1" noshade id="quote"></blockquote id="quote"> <hr noshade size="1">Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

I found this link: http://www.sqlteam.com/item.asp?ItemID=6002 Has anyone implemented this? I got it working for a GET command. I tried to look through 15seconds.com and they made reference to VB code, but not to TSQL. How do I set it up to use to PUT command instead of the GET command? Live to Throw
Throw to Live

I believe there isn;t any direct reference from TSQL, to accomplish may be you need to use VB or as per the link. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>