Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting up connection string in an FTP Task / Connection Manager

Status
Not open for further replies.

reisende

Programmer
Mar 16, 2004
74
US
Hello all,

I am having trouble getting my FTP Task to successfully upload a destination CSV file to our FTP server. The error I am getting is pasted below:

Error: 0xC001602A at MSPExport, Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: 200 Type set to I
227 Entering Passive Mode (69,59,190,167,204,247)
550 Permission denied on server. You are restricted to your account.

I am not the best with connection strings, but I'm pretty sure the issue is with my connection string in the FTP Connection. I am using a client specific username and password and attempting to upload to a sub folder called GP_In. I also have a dtsConfig file that contains the FTP Connection params since the GUI editor doesn't seem to save the password.

I'm just not sure how to configure the connection string to allow me access with the username and password and put the file into the needed directory. I would think that the username and password would be able to at least direct the file to the root directory of the user account?

Any ideas, suggestions or examples would be greatly appreciated.

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top