Dynamic Connection in FTP is not working | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Dynamic Connection in FTP is not working

I have a requirement in which files will get copied from various FTP location s.The problem is my FTP servername/username and password are dynamic.
To acheive this I created a Execute SQL task in which it gives me a result set of serverip/username/password.
Then in Foreachloop container i am passing those serverip/username/password.
And in my FTP connection manager i have set dynamic connection using expression ie @serverip+":21."+@username+"."+@password.
But it is failing with error Could not connect using FTP connection manager.
And Im ensuring that the file exist at the FTP location using a CLR function.If the file exists only then the package will execute.
And also my remote location at FTP is dynamic.
And i also tried dynamically setting ServerName and UserName property of FTP connection Manager
using expressions.
Any kind of help will be highly appreciated. Warm Regards,
See this http://social.msdn.microsoft.com/fo…/thread/3713e9a5-343a-4c5b-ac5d-1508cd5ab8be/ thread for information.
Hey hii thanks for a quick reply.
I solved my problem by creating a new useraccount and password.
And its working fine now with the above process.
But the problem which i found with my previous username and password was that the password was containing a " , "(comma).
I guess it was becoz of that.
Is there any way to handle special characters in password while using expressions or is it a issue related to account credentials.
But the user i was using was having admin priviliges
You can handle those special characters based on the quotes within the expression that you provide, what language you are using to provide the information in that ForEachLoop container?
hey i am just taking the result set of ExecuteSQL task in a object variable.
And in ForEachLoop—>For Each ADO enumerator im reading that object
And in paramater mapping i am storing the values in the variables .
And in the FTP connection manager im dynamically setting it using expression s

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |