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 |  
                                    | ahouseStarting Member
 
 
                                        27 Posts | 
                                            
                                            |  Posted - 2008-05-07 : 12:08:04 
 |  
                                            | I am establishing the columns for a fixed width text file in my DTS package. The fixed width file contains 7700 characters per line. I have been setting column markers with no problems until I get to about character 3,620 and then it simply will not create any more markers. If I keep trying to click to make the marker it eventually scrolls me back to around character 200. I thought I had possibly used too many markers but after removing some of the other ones, I still could not create any more. Are there any known restrictions for doing something like this? I'm stumped! |  |  
                                    | ahouseStarting Member
 
 
                                    27 Posts | 
                                        
                                          |  Posted - 2008-05-07 : 12:13:49 
 |  
                                          | More specifically, character 3640 is the last one I can add something to. If I try to add one there and drag it to the right, it takes me back to character 1. |  
                                          |  |  |  
                                    | rmiaoMaster Smack Fu Yak Hacker
 
 
                                    7266 Posts | 
                                        
                                          |  Posted - 2008-05-07 : 14:43:51 
 |  
                                          | What's data type of the column in sql table? |  
                                          |  |  |  
                                |  |  |  |