Push FTP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Push FTP

21 posts, Page 1 of 3

1 2 3 »»»

Push FTP

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, October 11, 2001 12:00 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1285

Andy Warren

Posted Friday, October 12, 2001 5:32 PM

SSCertifiable

Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463, Visits: 1,388

Pretty interesting. I agree that it doesn't make a lot of sense that the DTS task only does one way transfers - I've looked at the API recently and there ain't a lot of difference between get and put.

I like COM and compiled code for solutions, but for this I doubt it make much difference, would be style and not substance!

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #22347

Steve Jones - SSC Editor

Posted Monday, October 15, 2001 2:51 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

Personally I hate installing new software on my servers. I built this solution so that I could quickly and easily move this solution to another server without worrying about registering components, rebooting, etc.

In fact, I setup a new version of this DTS package on a server last week in about 3 minutes with no reboots.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #22348

Andy Warren

Posted Monday, October 15, 2001 3:42 PM

SSCertifiable

Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463, Visits: 1,388

I agree about reboots - not an issue when you build your own...or as much of an issue anyway. I get a lot of use/reuse out of code in COM dll's.

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #22349

darren.green

Posted Monday, October 29, 2001 10:51 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 05, 2006 1:47 PM
Points: 69, Visits: 1

You've wrapped it up nicely in ActX and no doubt it works great for you, but what about decent error information? I've been down this route but have converted to a COM DLL, so I can get meaningfull error messages. This was a no cost solution as I wrote the DLL and two seconds to install- copy file, register file.

Darren Green

Darren Green
SQLDTS.com | SQLIS.com | Konesans Ltd

Post #22350

Andy Warren

Posted Tuesday, October 30, 2001 6:01 AM

SSCertifiable

Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463, Visits: 1,388

Kowabunga, someone who likes to compile code!

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #22351

Steve Jones - SSC Editor

Posted Tuesday, October 30, 2001 9:02 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

I'll admit the error handling is low here. I could add some in ActiveX easily, though ftp.exe isn't great for doing this.
I really wanted this solution because I can deploy it completely from sql without being at the server.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #22352

jamyer

Posted Friday, November 02, 2001 9:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 22, 2011 9:03 AM
Points: 171, Visits: 16

Cool. I have a remote site that is about to rehost to W2K & S2K. Your solution will come in handy!

Post #22353

Steve Jones - SSC Editor

Posted Friday, November 02, 2001 10:33 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

Glad it will help. I've got some more details for how I handle the other side of the backups I will post soon.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #22354

ckempste

Posted Monday, April 01, 2002 10:40 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, Visits: 1

Nice article steve. I had the same problem a while ago, I did basically the same thing with a command file for the command line ftp with a cmdshell to run it, works ok but not very clean. in the end, I got a programmer to whip up a com routine for ftp, the beauty of this is that I can specify a specific port which the command line FTP.exe does not allow, therefore, making it very restrictive under some circumstances.

Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"

Post #22355

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions