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 |
|
jbosco1988
Starting Member
46 Posts |
 Posted - 2009-02-05 : 12:41:50
|
| I am trying to create a SSIS package that has 51 Fixed Width Columns from a text file. The first two columsn contain spaces.Column 1 (8 spaces)Width 8Column 2 (2 spaces)Width 2How do get spaces into the these columns?The 3rd Column has data and is a fixed width of 6.Thanks,James Bosco |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-05 : 12:45:11
|
| then what will be column delimiter in file? |
 |
|
|
jbosco1988
Starting Member
46 Posts |
Posted - 2009-02-05 : 13:13:50
|
| I think that is my problem, I really dont have one, I tried using spaces, but the data is mixed and matched, and the spaces wont work. I was able to import it into Access and the using the Fixed Width as the Column delimiter. And using a Start At point for each column. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 10:00:26
|
| nope. you need to have a consistent data delimiter in file. else ssis wont be able to identify what's start and end of column value |
|
|
|
jbosco1988
Starting Member
46 Posts |
Posted - 2009-02-10 : 12:11:52
|
| Ok that is kinda what i thought. Thanks allot again for the response. |
|
|
|
|
|
|
Spaces in a Fixed Width Import