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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2009-09-20 : 14:03:21
|
| Hi,I have to import a flat file with many rows that is named in the format RT.092This is a sample of the file:aaammm0120030101.00-00000090.37-0000004bbbnnn0220030102.00-00000050.18-0000008cccooo0320030103.00-00000035.17-0000007How do i import the file into a staging table? Do i use a flat file connector and how do i set it up since i don't have any delimiter? I will than need to split each rows further. ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-20 : 14:07:24
|
Do you have offset and lenght information for each field?It looks to me like fixed length...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2009-09-20 : 15:09:45
|
| Yea it's fixed length.I copied it abit wrong.Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-20 : 16:04:56
|
So you can step through import wizard and give needed information for field lenght and offset and column names and save as SSIS package.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SSIS and flat file