June 8, 2006 at 3:03 pm
I am having trouble setting the connection string for an FTP task. Let me explain....
I have a SQL table that contains all my source servers ( ip,port,user,pwd,folders etc ) . I created a ExecuteSQL task that loads this into a recordset. I then use a FOREACH ADO Enumerator to loop thru the table. So far so good. I am trying to set the connection string of a FTP Connection, using an expression, using the variables I maped in the FOREACH task.
I set the connectionstring on the FTP Connection Manager to "@[User::username] + ":" + @[User::password] + "@" + @[User::ipaddress] + ":21"" but it looks like the FTP task is always trying to connect to ":@:21" . Obviously it is not using my variables which are not assigned until inside the FOREACH task. I can see the variables with the correct values if I put in a break point. My guess is that it is only trying to set the FTP connection manager once when the package starts and not once for each loop in the FOREACH task. Any ideas ?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply