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 |
|
vswvsw
Starting Member
13 Posts |
 Posted - 2011-09-14 : 07:09:39
|
| hi alli am using a flat file to import to OLEDB through DTS.My text file looks like| Sr.No. |owne|Bil. Date |namecust| 1 |IIII|29.08.2010|seryukm | 2 |IVIV|30.05.2011|rewvert I have given column delimiter Vertical Bar {|} as and row delimiter as {CR}{LF}., but its showing error as the specified header or row delimiter is not found after scanning....Can any one please help me with this |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-14 : 09:00:53
|
| check if delimiters are consistent in file first------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
DTS import