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 |
|
bondwiththebest
Starting Member
46 Posts |
 Posted - 2008-08-29 : 10:06:17
|
| Hi ,I have a file which is in the format like shown below. I tried to split the file in middle so that the bottom part becomes like a usual tab delimited one. I am unable to get the top part working. It is all in a single column. I need to export the time, date, id all those values into DB. But i am unable to configure the top part of file so that it takes only the data. Can any one please help how i can configure in SSIS flat file source? Or is there any better way to do it ?????here is the file:--------start the filetime:date:id:aaa:bbb:cc:cdd:start datano data1 data2 data3 ....1 .5 .7 .8 2 .8 .8 .9 ......3 ......................4 ......................5 .................----------Thanks!! |
|
|
Will Riley
Starting Member
10 Posts |
Posted - 2008-09-04 : 16:51:26
|
| If the data always starts on a certain row, just skip the first "n" rows of the file and treat the rest as normal....Cheers,Willhttp://wills-blog.com |
 |
|
|
|
|
|
Help regarding flat file source