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 |  
                                    | JohnphPosting Yak  Master
 
 
                                        103 Posts | 
                                            
                                            |  Posted - 2014-03-17 : 12:08:04 
 |  
                                            | Hello, I want to parse a string in SSIS. My strings looks like this:CAT@@@DOG@@@yyyyMOUSE@@@bbb@@@aaar@@@s@@@gThey are separated by @@@ and I need code that is able to pull the 1st or 2nd or 3rd characters.Thanks. |  |  
                                |  |  |  |