Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 FTP Connection Manager Expression

Author  Topic 

Kaddidlehopper
Starting Member

1 Post

Posted - 2012-08-29 : 11:41:23
I am trying to create an expression for the ConnectionString Property. I understand the format of the ConnectionString should be FTPServer:Port.Username.Password. The problem is the username I have been given has a period in it. It seems this confuses the parsing of the string. Does anyone know of a text qualifier that will work in this instance which will enable the task to properly parse the string value? I've tried double quotes, single quotes and square brackets. I've also tried changing the deilimter for the fields to commas and semicolons...no luck.

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2012-09-04 : 02:28:51
could you instead use a script task to create your connection and do your thing via script task?

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -