Problem with FTP Task - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Problem with FTP Task

Author

Topic

SeekingWisdom
Starting Member

24 Posts

Posted - 2008-07-03 : 14:07:16

I am attempting to FTP a file that does already exist to a remote site. When I run the package the exception shown below is generated.

Does anyone have any ideas as to the cause of this problem.

Thanks,

Carlos.

Error: -1073548524
FTP Task/FTP Task
Time:7/3/2008 11:29:36 AM. Desc:File usage type of connection "ECustomsSelect.txt" should be "FileExists" for operation "Send".

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-03 : 16:22:58

my idea is:
you have a "fpt connection manager" with operation "send files". ok this is the receiving manager.
you have a "file connection manager" -> pointing to the file which should be sent to the remote site. in this file connection manager you have to choose the usage typ "Existing File", because this is the sending manager, but your choice was maybe "Create File".
hope that helps.
Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

SeekingWisdom
Starting Member

24 Posts

Posted - 2008-07-03 : 16:35:25

Thank you Webfred.

I am not able to paste screen shots of the file connection definition. Please note its definition though.

File Connection Definition:

Usage Type: Existing File

Any other ideas. Please!

I am at the east-coast so I will be leaving shortly for the weekend. Perhaps we can catch up Monday? Yes?

Thanks,

Carlos.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-03 : 16:43:43

ok, we can catch up monday.
have a nice weekend without errors!

Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

SeekingWisdom
Starting Member

24 Posts

Posted - 2008-07-07 : 11:22:22

Good Morning!

Question:

I am able to change the package to point the file to be FTPed locally, on my pc. Additionally the file does exist so that the file definition for the "File Connection Manager Editor" is set to "Existing File". The package does run successfully.

When I change the file definition to point to the "production" server and attempt to run it, with the same "existing file" declaration the package fails. Any ideas on the cause of this problem?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-07 : 13:15:19

Hello!
There are lots of questionmarks...because i cannot see your environment.
Do you run the package on your client-pc or on the production-server?
Is the path to the file like
E:\somewhere\file2upload.txt and E: is maybe a link that is known only on your client so the
path to the file should look like this:
\\production_server\shared_area\somewhere\file2upload.txt

Sorry, but there are many "maybe"...
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

SeekingWisdom
Starting Member

24 Posts

Posted - 2008-07-07 : 15:13:24

Thank you for your reply.

The path specified is as follows:

\\lv03svpdwsql1\BusinessIntelligence\FTP\ECustomsSelect.txt

The one difference being that I do not have a specific drive letter. As I see it the production server "lv03svpdwsql1" on the network is immediately identified within the package and the file is visible as mapped by the path.

Thank you again.

Carlos.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-07-07 : 16:21:34

So the error still happens. Yes?

I've tested both cases.
c:\test.txt --> FTP-Upload --> no error
\\servername\foo\test.txt --> FTP-Upload --> no error

Information to compare:

VS:
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00

FTP Connection Manager:
Server name: ftp.somewhere.com
Server port: 21
User name: myname
Password: mypassword

Test connection --> succes

File Connection Manager: (Connection Manager Type is "File" not "Flatfile")
Usage type: Existing file
File: \\servername\foo\test.txt (got it via button "Browse...", so it real exists)

FTP Task:
General: FTPConnection= FTP Connection Manager
General: StopOnFailure=TRUE

File Transfer: IsRemotePathVariable = FALSE
File Transfer: Remote Path = /my/path/todestiny
File Transfer: OverWriteFileAtDest = FALSE
File Transfer: IsLocalPathVariable = FALSE
File Transfer: LocalPath = <Name of flatfile-connection>
File Transfer: Operation = Send files
File Transfer: IsTranferAscii = FALSE

Experession: NOTHING

That's all.

Greetings
Webfred

There are 10 types of people in the world: Those who understand binary, and those who don't...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources