dbTalk Databases Forums  

Best way to read "Ragged-Right" file for parsing?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Best way to read "Ragged-Right" file for parsing? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Peter A. Schott
 
Posts: n/a

Default Best way to read "Ragged-Right" file for parsing? - 10-05-2004 , 05:21 PM






What is the best method to read a ragged-right type file for parsing if I'd
also like to use an IDENTITY column to order the rows? I need to parse some
log files that have several rows grouped together with no link between the
rows. It seems that I should be able to read this in through Bulk Insert or
similar and skip the PK/Identity column in the table.

Any ideas from someone who's been there?

Thanks.

-Pete Schott

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.