Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Articles Requested
»
SSIS - FTP Task - Send Files
SSIS - FTP Task - Send Files
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, June 23, 2011 12:00 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Can someone build a short tutorial on how to send a file to an FTP site?
Maybe show an export of a text file into SQL Server as the first step in a package, or dynamically picking a file, perhaps a .bak or .trn file?
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1130721
bisqldave
bisqldave
Posted Wednesday, June 29, 2011 5:25 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, May 13, 2012 9:07 PM
Points: 3,
Visits: 5
I can do this article if no one else has done it yet...
Thanks...
Post #1133604
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, June 29, 2011 9:37 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
You are welcome to tackle it. No one has responded or submitted yet.
However please tackle one article at at time. IF you want this one respond here and leave a note on any other articles requested threads that you are doing this one.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1133840
Jeff Moden
Jeff Moden
Posted Tuesday, November 29, 2011 6:36 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Steve,
Do you or Red Gate have an FTP test site we could send and retrieve files to and from?
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1213633
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, November 29, 2011 9:33 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
We have one. I'll see if I can get a test account posted.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1213659
Jeff Moden
Jeff Moden
Posted Thursday, December 01, 2011 4:41 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112,
Visits: 27,038
Steve Jones - SSC Editor (11/29/2011)
We have one. I'll see if I can get a test account posted.
That would be great. Thanks, Steve. The reason I ask, of course, is for two reasons... My current job doesn't work with any FTP sites that allow for such testing and it would be real handy to have a place where folks reading such an article can practice (with limits, of course).
If someone writes an article on using the SSIS FTP Task, I might be able to offer up one of the older "custom" methods that I used that is still in use at some of my previous companies. Heh... of course, it'll be highly controversial.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1214508
Raunak Jhawar
Raunak Jhawar
Posted Tuesday, April 03, 2012 11:47 PM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 946,
Visits: 1,740
Is this task been taken up by anybody. If not, I can do it.
Regards/Raunak
Now a member of Linkedin
Please visit the all new
Performance Point Forum
Please visit the all new
Data Mining and Business Analytics Forum
Post #1277795
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, April 04, 2012 9:11 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Take it, since you did the other FTP one.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1278154
Raunak Jhawar
Raunak Jhawar
Posted Wednesday, April 04, 2012 9:17 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 946,
Visits: 1,740
Aah...you remember
Regards/Raunak
Now a member of Linkedin
Please visit the all new
Performance Point Forum
Please visit the all new
Data Mining and Business Analytics Forum
Post #1278162
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.