If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Creating a fixed Length text file

I am currently in a big fix. The client wants my company to generate a fixed
length text file from our SQL Server 7 database. I already know how to import
their data by using a schema.ini but I have only found ways to export the
data from our system in a delimited format.

Does anyone know how to create a fixed length text file without manual manipulation
by users. All the code samples I have found is for creating delimited files
for export. It is imperative that I find a way because the client only wants
the data in a fixed length format.

"Rob Pesce" <rpesce@visto.com> wrote in message
news:3a0b3414$1@news.devx.com...
>
> I am currently in a big fix. The client wants my company to generate a
fixed
> length text file from our SQL Server 7 database. I already know how to
import
> their data by using a schema.ini but I have only found ways to export the
> data from our system in a delimited format.
>
> Does anyone know how to create a fixed length text file without manual
manipulation
> by users. All the code samples I have found is for creating delimited
files
> for export. It is imperative that I find a way because the client only
wants
> the data in a fixed length format.

Re: Creating a fixed Length text file

Look at SQL's BCP (Bulk Copy Process) It's a commandline facility that is
extremely quick. You need to set up a schema file first, but once that's
set up it should be simple. The hard part is finding decent documentation
on the schema files format. I'd look at some 3rd party books at the local
book store.

...joe

"Rob Pesce" <rpesce@visto.com> wrote:
>
>I am currently in a big fix. The client wants my company to generate a
fixed
>length text file from our SQL Server 7 database. I already know how to
import
>their data by using a schema.ini but I have only found ways to export the
>data from our system in a delimited format.
>
>Does anyone know how to create a fixed length text file without manual manipulation
>by users. All the code samples I have found is for creating delimited files
>for export. It is imperative that I find a way because the client only
wants
>the data in a fixed length format.