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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | KaddidlehopperStarting 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. |  |  
                                    | yosiaszMaster 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 |  
                                          |  |  |  
                                |  |  |  |