Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

FTP To Replace xp_cmdshell in SQL Server

I need a solution on how to replace a line in my sql stored procedure that is using xp_cmdshell with FTP in SSIS.

Please, let me know if this is possible?  Can you replace your sql that is using xp_cmdshell with FTP in SSIS.  Rather then using xp_cmdshell to call your file, now use FTP instead.
0
Favorable
Asked:
Favorable
5 Solutions
 
David ToddSenior DBACommented:
Hi,

It depends on what you are doing with xp_cmdshell.

Yes, there is an ftp object in SSIS.

For FTPS I used a third party object. Once I had sorted everything out it was quite solid and stable.

HTH
  David
0
 
FavorableAuthor Commented:
We have some stored procedures that uses xp_cmdshell to read files from a direction, but instead of using that, we want to replace with ftp in SSIS.
Will this serve the same purpose as the ftp to access the files?
0
 
nishant joshiTechnology Development ConsultantCommented:
yes, you can use ftp task in ssis. its good to use ssis ftp instead of xp_cmdshell.

for your dynamic command syntax you have to use ssis expressions to accomplish all required needs.

Thanks,
Nishant
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
FavorableAuthor Commented:
Could you point me to some steps that accomplished a similar task?
0
 
nishant joshiTechnology Development ConsultantCommented:
please check below link

http://nishantcomp2512.blogspot.in/p/sql-severing.html

over there you will find ssis tutorial book by kartiketanana.

This book contains detail description about ftp task.

Thanks,
Nishant
0
 
Anthony PerkinsCommented:
We have some stored procedures that uses xp_cmdshell to read files from a direction
What does this mean? Are you:
A) Doing a FTP GET operation or
B) Doing a FTP PUT operation or
C) Something else.
0
 
FavorableAuthor Commented:
We have xp_cmdshell that is doing get data from a file direction.  Now, we want to change that to FTP GET operation.
0
 
nishant joshiTechnology Development ConsultantCommented:
In ssis ftp task contains option  for send file and receive file.

For that you can get as well as put files.

Nishant
0
 
FavorableAuthor Commented:
Thanks everyone
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now