FTP task - I need to PUT to FTP site

#1

I need to PUT multiple files to an internal FTP server on a daily basis.
The FTP task seems to allow me to GET files "from the internet" but I don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since this is a
secure FTP server.

Any help will be appreciated.

Terry

#2

The builtin DTS FTP task only does a limited GET.

How about something like these two methods

1.
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

2. Use a batch file and call it from an ExecuteProcess task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terry Garber" <tgarber (AT) sartox (DOT) com> wrote

Quote:

I need to PUT multiple files to an internal FTP server on a daily basis.
The FTP task seems to allow me to GET files "from the internet" but I
don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since this is
a
secure FTP server.

Any help will be appreciated.

Terry

#3

Regarding option 2 - how do I get an error code from FTP back to the DTS
package so I know the FTP failed?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The builtin DTS FTP task only does a limited GET.

How about something like these two methods

1.
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

2. Use a batch file and call it from an ExecuteProcess task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terry Garber" <tgarber (AT) sartox (DOT) com> wrote in message
news:%23Ph03$TMEHA.3420 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
I need to PUT multiple files to an internal FTP server on a daily basis.
The FTP task seems to allow me to GET files "from the internet" but I
don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since this
is
a
secure FTP server.

Any help will be appreciated.

Terry

#4

You should see an icon in the toolbox for the task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Neil Jarman" <neil (AT) tNOiSPAMvPLEASEy (DOT) co.uk> wrote

Quote:

Hi Allen,

I have just seen your site re SQLDTS FTP Task.

I'm not clear what will happen when I install it - does it create an icon
the the DTS screen, or is it for use with VB?

I'm not in a position to try it right now, so a little clarification would
help.

Forgive my begginer's status!

NEIL

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:OWn9zHUMEHA.1468 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
The builtin DTS FTP task only does a limited GET.

How about something like these two methods

1.
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

2. Use a batch file and call it from an ExecuteProcess task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terry Garber" <tgarber (AT) sartox (DOT) com> wrote in message
news:%23Ph03$TMEHA.3420 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
I need to PUT multiple files to an internal FTP server on a daily
basis.
The FTP task seems to allow me to GET files "from the internet" but I
don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since
this
is
a
secure FTP server.

Any help will be appreciated.

Terry

#5

Hi Allen,

I have just seen your site re SQLDTS FTP Task.

I'm not clear what will happen when I install it - does it create an icon
the the DTS screen, or is it for use with VB?

I'm not in a position to try it right now, so a little clarification would
help.

Forgive my begginer's status!

NEIL

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

The builtin DTS FTP task only does a limited GET.

How about something like these two methods

1.
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

2. Use a batch file and call it from an ExecuteProcess task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terry Garber" <tgarber (AT) sartox (DOT) com> wrote in message
news:%23Ph03$TMEHA.3420 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
I need to PUT multiple files to an internal FTP server on a daily basis.
The FTP task seems to allow me to GET files "from the internet" but I
don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since this
is
a
secure FTP server.

Any help will be appreciated.

Terry

#6

You may need to refresh the DTS designer Cache and/or restart Enterprise
Manager. Right-click "Data Transformation Services" in the tree view,
"Properties", "Refresh Cache" if cache is on.

The installation will register the task, including the additional
information required to install it in the tool box.

--
Darren Green
http://www.sqldts.com

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

You should see an icon in the toolbox for the task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Neil Jarman" <neil (AT) tNOiSPAMvPLEASEy (DOT) co.uk> wrote in message
news:cebbnk$rdp$1$8302bc10 (AT) news (DOT) demon.co.uk...
Hi Allen,

I have just seen your site re SQLDTS FTP Task.

I'm not clear what will happen when I install it - does it create an
icon
the the DTS screen, or is it for use with VB?

I'm not in a position to try it right now, so a little clarification
would
help.

Forgive my begginer's status!

NEIL

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message
news:OWn9zHUMEHA.1468 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
The builtin DTS FTP task only does a limited GET.

How about something like these two methods

1.
SQLDTS File Transfer Protocol Task
(http://www.sqldts.com/Default.aspx?302)

2. Use a batch file and call it from an ExecuteProcess task.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terry Garber" <tgarber (AT) sartox (DOT) com> wrote in message
news:%23Ph03$TMEHA.3420 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
I need to PUT multiple files to an internal FTP server on a daily
basis.
The FTP task seems to allow me to GET files "from the internet" but
I
don't
see how to PUT files "to the internet".

I need "the internet" type of connection with IP, Userid/Pwd since
this
is
a
secure FTP server.

Any help will be appreciated.

Terry

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

FTP task - I need to PUT to FTP site

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

FTP task - I need to PUT to FTP site - 05-03-2004 , 01:53 PM

Re: FTP task - I need to PUT to FTP site - 05-03-2004 , 02:12 PM

Re: FTP task - I need to PUT to FTP site - 05-05-2004 , 09:25 AM

Re: FTP task - I need to PUT to FTP site - 07-29-2004 , 12:25 PM

Re: FTP task - I need to PUT to FTP site - 07-29-2004 , 12:38 PM

Re: FTP task - I need to PUT to FTP site - 07-30-2004 , 04:53 AM