<brienc@gmail.com> wrote in message
news:1098386234.727132.313330@c13g2000cwb.googlegroups.com...
> I have seen this question a few times in the past, but there has never
> been a good answer. I have a very large binary file that I want to
> read into a SQL Server table. Each record in the file is a fixed size.
> It seems like I should be able to use DTS to do this, or at the worst
> write some VB code to do it. Does anyone have a good solution?
> Thanks in advance!
>

<brienc@gmail.com> wrote in message
news:1098703160.035579.41330@z14g2000cwz.googlegroups.com...
> It is a large binary file with many records. Each record has several
> fields of differing length. I want to break up the file and read it
> into SQL Server so that each record is a row in a table and each field
> is a column in the table. Thanks!
> Brien
>

<brienc@gmail.com> wrote in message
news:1098715694.050537.98910@c13g2000cwb.googlegroups.com...
> The fields are fixed length, but are not text. BCP and DTS seem to
> only work with text formats, not binary. Here's an example:
>
> Let's say that my data consists of a list of integers, one byte each.
> DTS could handle the data if it looked like this:
> (ASCII)
> 1
> 2
> 3
> 4
>
> My data looks like this:
> (binary)
> 00000001000000100000001100000100
>
> It seems like there should be some way to tell SQL server to read in
> one byte at a time and interpret it as an int. (my data is much more
> complicated, but this is the general idea)
>