In borland.public.delphi.database.sqlservers, David Clegg <> wrote in message
<3daf68d...@newsgroups.borland.com>...

Never mind. I found an acceptable cludge. If I first store the Paradox bytes
field value into a SQL Serverv archar field (in the DTS script), it converts
it to a string representation of the hex value. From there it is simple to
convert the string to int by using the eval function e.g:

DTSDestination("SomeVarcharField") = DTSSource("SomeBytesField")
DTSDestination("SomeBytesFieldNowStoredAsInt") = eval("&H" &
DTSDestination("SomeVarCharField")  & "&")

--
***Posted by Jake's Custom Newsgroup Reader***

Posted with Jake's Super Newsreader--ALPHA TEST  Expires 12/31/2002 ALPHA   Version 0.9.1.402
Download your free alpha test copy from Jake's Delphi Page at http://www.xnet.com/~johnjac

In borland.public.delphi.database.sqlservers, David Clegg <> wrote in message
<3daf97c...@newsgroups.borland.com>...

My newsreader insists on wrapping, but the above two lines should be one the
same line.

--
***Posted by Jake's Custom Newsgroup Reader***

Posted with Jake's Super Newsreader--ALPHA TEST  Expires 12/31/2002 ALPHA   Version 0.9.1.402
Download your free alpha test copy from Jake's Delphi Page at http://www.xnet.com/~johnjac