How can I achieve the foll in dts

#1

Hi,
I need to download a file from an ftp server via my dts package. The order is

connect to ftp server
check if file exists (the name is always the same)
if yes, down load file and delete copy on ftp server
rename file from test to test.txt
parse file (This I got working)

I need help with the ftp part.

Thanks

#2

Hi Chris,

Quote:

connect to ftp server
check if file exists (the name is always the same)

Within DTS there is a FTP task where you can select a source, destination,
login information, etc. If the file does not exists this task will fail, so
automatically stopping the rest of your DTS package.

Quote:

rename file from test to test.txt
Once the FTP task has completed successfully you could have use an ActiveX

task to rename the file using the FileSystemObject model or write a batch/cmd
file to do the renaming and execute it with a Execute Process Task.

"Chris" wrote:

Quote:

Hi,
I need to download a file from an ftp server via my dts package. The order is

connect to ftp server
check if file exists (the name is always the same)
if yes, down load file and delete copy on ftp server
rename file from test to test.txt
parse file (This I got working)

I need help with the ftp part.

Thanks

#3

Hello rb,

The package does not automatically have to fail. You could handle the "No
File" through the "On Failure" precedence constraint. You could also set
up the package to allow n errors before failing.

To rename the file I would be tempted to use the File System task from the
toolbox.

allan

Quote:

Hi Chris,

connect to ftp server
check if file exists (the name is always the same)
Within DTS there is a FTP task where you can select a source,
destination, login information, etc. If the file does not exists this
task will fail, so automatically stopping the rest of your DTS
package.

rename file from test to test.txt

Once the FTP task has completed successfully you could have use an
ActiveX task to rename the file using the FileSystemObject model or
write a batch/cmd file to do the renaming and execute it with a
Execute Process Task.

"Chris" wrote:

Hi,
I need to download a file from an ftp server via my dts package. The
order is
connect to ftp server
check if file exists (the name is always the same)
if yes, down load file and delete copy on ftp server
rename file from test to test.txt
parse file (This I got working)
I need help with the ftp part.

Thanks

#4

Hi Alan,

You are perfectly correct, both the success and failure can be handled.

Ray

"Allan Mitchell" wrote:

Quote:

Hello rb,

The package does not automatically have to fail. You could handle the "No
File" through the "On Failure" precedence constraint. You could also set
up the package to allow n errors before failing.

To rename the file I would be tempted to use the File System task from the
toolbox.

allan

Hi Chris,

connect to ftp server
check if file exists (the name is always the same)
Within DTS there is a FTP task where you can select a source,
destination, login information, etc. If the file does not exists this
task will fail, so automatically stopping the rest of your DTS
package.

rename file from test to test.txt

Once the FTP task has completed successfully you could have use an
ActiveX task to rename the file using the FileSystemObject model or
write a batch/cmd file to do the renaming and execute it with a
Execute Process Task.

"Chris" wrote:

Hi,
I need to download a file from an ftp server via my dts package. The
order is
connect to ftp server
check if file exists (the name is always the same)
if yes, down load file and delete copy on ftp server
rename file from test to test.txt
parse file (This I got working)
I need help with the ftp part.

Thanks

#5

Hey, Thanks lads. Will work on this right away. This is good.

"Chris" wrote:

Quote:

Hi,
I need to download a file from an ftp server via my dts package. The order is

connect to ftp server
check if file exists (the name is always the same)
if yes, down load file and delete copy on ftp server
rename file from test to test.txt
parse file (This I got working)

I need help with the ftp part.

Thanks

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

How can I achieve the foll in dts

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

How can I achieve the foll in dts - 06-06-2006 , 03:43 PM

RE: How can I achieve the foll in dts - 06-07-2006 , 04:00 AM

RE: How can I achieve the foll in dts - 06-07-2006 , 04:31 AM

RE: How can I achieve the foll in dts - 06-07-2006 , 05:11 AM

RE: How can I achieve the foll in dts - 06-07-2006 , 11:21 AM