SSIS FTP Error

Connection can not be established.  Server name, port number, or credentials may be invalid.

I just got that message when trying to enter a perfectly valid set of connection/credential info into an SSIS package.  But testing the connection failed.

Turns out my issue, and maybe your issue too, is that SSIS doesn’t remove white space from the server name textbox.  So if you pasted in the name of the FTP server, as I did, you might have fallen victim to the “trailing space” that is frequently copied with your text, and instead of trying to connect to “ftp.com” it tried to connect to “ftp.com ” notice the extra space.

Advertisements

2 thoughts on “SSIS FTP Error

  1. Chris:

    I have a question that you may help me I used the FTP Task and it work in development with the user name and password but when I load the Job with the SSIS task it give me a error on FTP connection

    Any Ideas?

    Bill

  2. The only thing I can think of is that it’s possible that the username and password are not being transferred to the ssis package. You might want to make sure that you have it saving that data.

    Also, you’ll want to make sure that you production machine can create outbound FTP connections. Many antivirus programs block this (not to mention firewalls).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s