Re: Uploading Files via DTS

#1

I have only ever used a GUI FTP client in Windows. In Unix/Oracle I
have run FTP commands but only on a manual line by line basis.

I am not sure how I would put such into a DTS package.

Regards
Dazza

SQL wrote:

Quote:

Can you use FTP?

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I know how to download files from the internet via DTS but wish to know if
it is possible to upload them as well.

I have SQL Server Personal edition and I wish to automate a job that creates
an Excel file then uploads it to a directory on my personal webspace with
NTL World.

I have a package that creates the Excel file already and I have to upload it
manually each time it is created. I have SQL Server Personal edition and I
wish to automate a job that creates the Excel file then uploads it to a
directory on my personal webspace with NTL World as part of the package.

Is this possible?

Regards
Dazza

#2

Look at the FTP task (first one on the left)

http://sqlservercode.blogspot.com/

"Dazza" wrote:

Quote:

I have only ever used a GUI FTP client in Windows. In Unix/Oracle I
have run FTP commands but only on a manual line by line basis.

I am not sure how I would put such into a DTS package.

Regards
Dazza

SQL wrote:
Can you use FTP?

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I know how to download files from the internet via DTS but wish to know if
it is possible to upload them as well.

I have SQL Server Personal edition and I wish to automate a job that creates
an Excel file then uploads it to a directory on my personal webspace with
NTL World.

I have a package that creates the Excel file already and I have to upload it
manually each time it is created. I have SQL Server Personal edition and I
wish to automate a job that creates the Excel file then uploads it to a
directory on my personal webspace with NTL World as part of the package.

Is this possible?

Regards
Dazza

#3

The link you gave did not describe the FTP function at all !!

However, I have tried using a batch file that calls a script but, whilst all
runs fine in the package, the file is not uploaded.

The batch file content is:

ftp -s:C:\BatchFiles\UploadFile.scr

the script file UploadFile.scr contains

open upload.ntlworld.com
user
{my user name}
{my password}

cd DVDList

put D:\Application Data\My Documents\Excel\Filename.xls

quit

I have even set a log file in case anything was recorded but nothing out of
the ordinary appears in it and everything appears to have run fine.

I even tried to upload the file manually in a command prompt and again all
showed fine but no file was uploaded !!

My bald patch is getting shineier over this !!

Regards
Dazza

"SQL" <SQL (AT) discussions (DOT) microsoft.com> wrote

Quote:

Look at the FTP task (first one on the left)

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I have only ever used a GUI FTP client in Windows. In Unix/Oracle I
have run FTP commands but only on a manual line by line basis.

I am not sure how I would put such into a DTS package.

Regards
Dazza

SQL wrote:
Can you use FTP?

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I know how to download files from the internet via DTS but wish to know
if
it is possible to upload them as well.

I have SQL Server Personal edition and I wish to automate a job that
creates
an Excel file then uploads it to a directory on my personal webspace
with
NTL World.

I have a package that creates the Excel file already and I have to
upload it
manually each time it is created. I have SQL Server Personal edition
and I
wish to automate a job that creates the Excel file then uploads it to a
directory on my personal webspace with NTL World as part of the
package.

Is this possible?

Regards
Dazza

#4

What I was referring to was the FTP task in the DTS designer, the link is my
blog, I always attach that
You can also do this, create a BAT file that will execute your SCR file
Then you can do something like this
xp_cmdshell 'C:\MyFTP.BAT'

"Dazza" wrote:

Quote:

The link you gave did not describe the FTP function at all !!

However, I have tried using a batch file that calls a script but, whilst all
runs fine in the package, the file is not uploaded.

The batch file content is:

ftp -s:C:\BatchFiles\UploadFile.scr

the script file UploadFile.scr contains

open upload.ntlworld.com
user
{my user name}
{my password}

cd DVDList

put D:\Application Data\My Documents\Excel\Filename.xls

quit

I have even set a log file in case anything was recorded but nothing out of
the ordinary appears in it and everything appears to have run fine.

I even tried to upload the file manually in a command prompt and again all
showed fine but no file was uploaded !!

My bald patch is getting shineier over this !!

Regards
Dazza

"SQL" <SQL (AT) discussions (DOT) microsoft.com> wrote in message
news:A771CBE0-4734-4221-ACFC-A520E76EE7F3 (AT) microsoft (DOT) com...
Look at the FTP task (first one on the left)

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I have only ever used a GUI FTP client in Windows. In Unix/Oracle I
have run FTP commands but only on a manual line by line basis.

I am not sure how I would put such into a DTS package.

Regards
Dazza

SQL wrote:
Can you use FTP?

http://sqlservercode.blogspot.com/

"Dazza" wrote:

I know how to download files from the internet via DTS but wish to know
if
it is possible to upload them as well.

I have SQL Server Personal edition and I wish to automate a job that
creates
an Excel file then uploads it to a directory on my personal webspace
with
NTL World.

I have a package that creates the Excel file already and I have to
upload it
manually each time it is created. I have SQL Server Personal edition
and I
wish to automate a job that creates the Excel file then uploads it to a
directory on my personal webspace with NTL World as part of the
package.

Is this possible?

Regards
Dazza

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

Re: Uploading Files via DTS

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

Re: Uploading Files via DTS - 10-01-2005 , 01:22 PM

Re: Uploading Files via DTS - 10-01-2005 , 01:35 PM

Re: Uploading Files via DTS - 10-01-2005 , 02:21 PM

Re: Uploading Files via DTS - 10-02-2005 , 04:28 AM