Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Whats the easiest way to read the first 10 characters of a flat file Expand / Collapse
Posted Thursday, May 9, 2013 1:14 AM



Group: General Forum Members
Last Login: Today @ 2:30 AM
Points: 7,713, Visits: 18,592
That's a neat technique, thanks for posting.

Quite a common requirement seems to be reading the first n characters, or the first row, of a text file to determine its type/layout before directing to the appropriate dataflow - I reckon you're well on the way to cracking that with this.

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

Just when you think your code is idiot-proof, the world invents a better idiot.
Post #1450905
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse