importing binary data

[coladmin]

hello I have a database that has an export function to a binary file and I would like to import this data into SQL on a regular basis using DTS. can anyone give me some recommendations on how to import the binary data

thanks in advance

 

[AlexCuse]

You could probably do this with DTS provided the table you are importing it too has columns defined as binary or varbinary, and the file you want to import is somehow delimited.

What does your file structure look like?

A wise man once said
"The only thing normal about database guys is their tables".

 

[coladmin]

the file has the following structure

no delimitmers

a header and a detail section and I have documentaiton on each records size in bytes and data type. I have tried to use DTS and it does recnogize the file at all.

 

[AlexCuse]

Have you tried changing the filename extension to .txt and bringing it in as a text file?

A wise man once said
"The only thing normal about database guys is their tables".

 

[coladmin]

yes and I did not have any luck with that

 

[AlexCuse]

Are you familiar with BCP? You may be able to use that here.

You also might be able to use fox to bring it into a dbf as an intermediate step?

I am really grasping at straws here, sorry I can't be of more help.

Alex

A wise man once said
"The only thing normal about database guys is their tables".