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.
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.