Re: ftp task
From: Kevin Thomas (Kevin_at_FakeEmailAddresses.com)
Date: 08/24/04
- Next message: Darren Green: "Re: DTS and the Internet"
- Previous message: Crazy About SQL Server: "Executed DTS package from a VB script in another package"
- In reply to: don: "Re: ftp task"
- Next in thread: don: "Re: ftp task"
- Reply: don: "Re: ftp task"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 13:23:19 -0700
If you go to the command prompt and type:
"ftp -?"
you will see the definitions for the various parameters to FTP. For
example, the -s:filename, "specifies a text file containing FTP commands;
the commands will automatically run after FTP starts."
I don't really know why your script file wouldn't work if the same commands
contained within work fine when you execute them manually.
Kevin
"don" <don@discussions.microsoft.com> wrote in message
news:70D3B2BC-B5E0-4297-B401-4768CF8A29A8@microsoft.com...
> Kevin,
>
> I dont get it. i run the ftp from the command line and it works, when i
> put those same entries in the parameter file it fails. Is there some
> documentation that shows the parameter file make up, for example what does
> the -s mean. I set debugging on but to be honest the error codes that are
> returned are meaningless. (i.e. 'Step Error code: 80040496 Step Error Help
> File:sqldts80.hlp Step Error Help Context ID:4900). Thanks for your
> assistance..
>
> "Kevin Thomas" wrote:
>
>> Hi Don,
>>
>> Within the script file you'll need to issue the commands to navigate to
>> the
>> directory you want to be in. Of course, this assumes the host will allow
>> you to do this. In any case, it would look something like this:
>>
>> open genesis (genesis name is stored in the host file)
>> username
>> password
>> cd SomeFolderName
>> put c:\filetosend
>> close
>> quit
>>
>>
>> Remember, this is a script file so go ahead and add any commands to it
>> that
>> you would normally do by hand to accomplish the same task.
>>
>> Kevin
>>
>>
>> "don" <don@discussions.microsoft.com> wrote in message
>> news:03D479F8-2F01-47DB-9E59-76A9EAC6B9FD@microsoft.com...
>> > Kevin,
>> > I'm relatively new to sqlserver and dts. I noticed in the sample file
>> > there was no place to specify the directory the file was being xferred
>> > to.
>> > I'm trying to send a file on a regular scheduled basis using the
>> > following
>> > parameters:
>> > (1) remote site = genesis (or ip address xx.x.x.xx)
>> > (2) file = c:\filetosend
>> > (3) user name (to logon to remote site)
>> > (4) p/w (to sign on to remote site)
>> > I stored this info in a .txt file as you suggested and it looks like
>> > this
>> >
>> > open genesis (genesis name is stored in the host file)
>> > username
>> > password
>> > put c:\filetosend
>> > close
>> > quit
>> >
>> > (where do i put the directory name of where the file is going)
>> >
>> >
>> >
>> >
>> > "Kevin Thomas" wrote:
>> >
>> >> To send via ftp, use the "Execute Process Task"
>> >> In the "Win32 process" field, type "ftp"
>> >> In the "Parameters" field, type "-s MyFTPScript.txt"
>> >>
>> >> Where the file "MyFTPScript.txt" contains the commands you want to
>> >> issue
>> >> to
>> >> the ftp process. I might look something like:
>> >> open ftp.somesite.com
>> >> MyUserName
>> >> MyPassword
>> >> put TheFileIWantToTransfer.txt
>> >> close
>> >> quit
>> >>
>> >>
>> >> Enjoy,
>> >>
>> >> Kevin
>> >>
>> >> "dthaler@lccc.edu" <anonymous@discussions.microsoft.com> wrote in
>> >> message
>> >> news:ba1c01c48939$7f4b50c0$a401280a@phx.gbl...
>> >> > can i setup an ftp task to send data to an internet site?
>> >> > when i invoke the ftp task the only option for the 'to
>> >> > destination' is a directory?
>> >>
>> >>
>> >>
>>
>>
>>
- Next message: Darren Green: "Re: DTS and the Internet"
- Previous message: Crazy About SQL Server: "Executed DTS package from a VB script in another package"
- In reply to: don: "Re: ftp task"
- Next in thread: don: "Re: ftp task"
- Reply: don: "Re: ftp task"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
