Problem with FTP Task in SSIS on SQL2005

Question

Problem with FTP Task in SSIS on SQL2005

Mark Butler-141638

Old Hand

Points: 330
More actions
May 9, 2006 at 4:50 pm

#190575
Hi, I wonder if anyone can solve my FTP Task problem?
- I have established an FTP connection to my remote FTP server. When I test the connection in the connection manager it works fine. When I close and reopen the FTP connection editor the user name is shown correctly, but I havce to re-enter my password to test the connection again;
- I establish an FTP Task using the same FTP connection manager, set the operation to 'Receive files' , set IsRemotePathVariable to 'false', set the RemotePath to '/TRGL.TXT', which is the name of my text file in the root directory of the FTP server;
- I have made a File connection manager which points to an 'Existing folder' being the c:\ drive on my local computer, set the IsLocalPathVariable in the FTP task editor to 'False', referenced LocalPath to the File connection manager and set OverWriteFileAtDest to 'True'.
When I execute the task I get the error message:
[FTP task error]: File represented by "/TRGL.TXT" does not exist.
and I can't see any files in the '/' directory when I browse the FTP server using the elipses in for RemotePath in the FTP Task editor.
But, I can run http://FTP.exe at the command prompt using:
ftp> get /TRGL.TXT c:\TRGL.TXT
without any problems, and I can do the FTP in SSIS using the Execute Process Task, with the same logon, password and parameters, with out problem either.
I'm stumped. Does anyone know if I have made a silly error, or is this a known problem?
Many thanks
May 12, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 49 total)

You must be logged in to reply to this topic. Login to reply

Michael Grabscheid SSC Journeyman Points: 89 More actions · Answer 1

I have established an FTP connection to my remote FTP server. When I test the connection in the connection manager it works fine. When I close and reopen the FTP connection editor the user name is shown correctly, but I havce to re-enter my password to test the connection again;

I have had a similar problem with a stored password for an ftp connection not persisting. As a result, I cannot execute an ftp task, as I get these errors:

Error: 0xC001602A at CBTestPackage, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The password was not allowed

.Error: 0xC002918F at FTP Task, FTP Task: Unable to connect to FTP server using "FTP Connection Manager".

Task failed: FTP Task

Has anyone identified the fix for this?

Ahmet Akin Old Hand Points: 391 More actions · Answer 2

I also had the same problem as i tried to send flatfiles to a FTP-Host.

I get these error-messages:

"An Error occurred in the requested FTP operation. Detailed error description:The password was not allowed."

Does anyone knows who to solve this?

Ahmet Akin Old Hand Points: 391 More actions · Answer 3

I also had the same problem as i tried to send flatfiles to a FTP-Host.

I get these error-messages:

"An Error occurred in the requested FTP operation. Detailed error description:The password was not allowed."

Does anyone knows who to solve this?

Ahmet Akin Old Hand Points: 391 More actions · Answer 4

I also had the same problem as i tried to send flatfiles to a FTP-Host.

I get these error-messages:

"An Error occurred in the requested FTP operation. Detailed error description:The password was not allowed."

Does anyone knows who to solve this?

Tenny-133977 Old Hand Points: 308 More actions · Answer 5

Right click on your FTP connection manager, go to its Properties (the very bottom, not the Edit button), and type in the password.

save your package with EncryptSensitiveWithPassword.

That's how I made mine work. Let me know if it doesn't coz I too was figuring this out for the longest time when I first started.

Ahmet Akin Old Hand Points: 391 More actions · Answer 6

The Package works really fine, when i run my Package local, the flatfiles had been sent successfully to the FTP-Host.

But as i start the Package from the Management Studio, i get the same failure message as described above.

Do i also have to type in the password in the connection string (connection manager)?

Tenny-133977 Old Hand Points: 308 More actions · Answer 7

Try this then, use the package configuration file. Save the user name and password into the configuration file. Then change the package setting to DontSaveSensitive. Then try to run it from Management Studio. Let me know if you need help with saving info to configuration file.

Tenny-133977 Old Hand Points: 308 More actions · Answer 8

Or another option, if you have the package already set to EncyrptSensitivewithPassword, in management studio, set up a job that will call your dispatcher. Then go to the Command line tab, and type in the password of your package.

Ahmet Akin Old Hand Points: 391 More actions · Answer 9

Why should i have to protect my package with a password in Visual Studio in order to run my job in Management Studio properly? I thought that the setting "EncyrptSensitivewithPassword" just refers to the package or do i have to protect my packages with passwords in order to execute them on the management Studio?

Gunaseelan-339648 SSC-Addicted Points: 453 More actions · Answer 10

I have the same problem.

I can run http://ftp.exe and do my ftp task. but it just doesn't work when i do it through ftp task.

I'm connecting to a unix box and my path is in the /dir1/dir2/dir3/file.trg format.

i'm using a variable to store this value.

what is wrong? Anyone?

Kiran Gazz Valued Member Points: 60 More actions · Answer 11

Hello ,

I wanted to know how to make a dynamic FTP Connection. My FTP Server will be having a FTP server Name , File path, FTP Server Name, FTP User Name, FTP Password. Our Database maintains different FTP servers for different clients.In DTS we used below code in activex script task to connect to the FTP Dynamically.

"Set objTask = objPackage.Tasks(cstr("DTSTask_DTSFTPTask_2")).CustomTask

objTask.SourceLocation = 0

objTask.sourcesite = DTSGlobalVariables("g_str_ftpservername").Value

objTask.SourceUsername = DTSGlobalVariables("g_str_ftpusername").Value

objTask.SourcePassword = DTSGlobalVariables("g_str_ftppassword").Value

objTask.NonOverwritable = False

objTask.SourceFilename = srcFiles

objTask.destsite = DTSGlobalVariables("g_str_filelocation").Value

Now we are migrating our workflows to SSIS (SQL Server 2005). The problem is we are unable to find solution for dynamically connecting to FTP Server which maintains a password.

Can any body help please.

Thanks,

Kiran G

Elias Carlston SSC Journeyman Points: 79 More actions · Answer 12

Hi,

I have the same problem as the original poster, whose question didn't seem to be answered.

I can get a file via FTP from the command line, and the FTP connection in SSIS tests successfully, but the directories and files are not visible through SSIS.

Any help appreciated.

Thanks,

Elias

Mark Butler-141638 Old Hand Points: 330 More actions · Answer 13

Hi,

I haven't found a solution, but I have found a working around using the Execute Process Task. In the Execute Process Task Editor, Process page I set:

Executable to http://ftp.exe
Arguments to -s:FTP_Script.txt
Working directory to C:\

The C:\ directory contains my FTP_Script.txt file, which logons to the remote FTP server and transfer my file named TRGL.TXT from the FTP server root directory to the c:\ drive of the SQL server:

OPEN FTP_SERVER

logonid

password

GET /TRGL.TXT C:\trgl.txt

DELETE /TRGL.TXT

bye

It annoys the crap out of me, because it ignores the apparent functionality of the FTP Task, but what else can a bloke do?