I'm trying to bring over a text file into a SQL table, and the data has
got what appears to be low values in a field on it.

It's causing a problem when I try to load them into a table though. It
doesn't set it to spaces (which I am looking for later on to edit any
unfilled field) but with something else that I can't recognize, at least
by any means from within the Activex code available in SQL's DTS.

When I use Textpad to open the file, and try to display the field in
question, I get:

NUL(^@=0=0x0)

I figured checking

if DTSSource("col001") = NULL then
DTSDestination("Field1") = ""
else
DTSDestination("Field1") = DTSSource("col001")
end if

would take care of it, but it hasn't.

Anyone know what I've got to look for in order to edit it in the activex
script in DTS?

Any help appreciated.

Thanks

BC

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 4, 4:26*pm, Blasting Cap <goo... (AT) christian (DOT) net> wrote:
One way is to replace all occurances of char(0) with ' '. I'm pretty
sure vbscript has a replace function - or you can do it in sql like
this:

DECLARE@x varchar(10)

SET @x = 0x00000000000000000000

SELECT REPLACE(@x, CHAR(0), ' ')

HTH

Payson

On Jun 5, 7:14*am, Payson <payso... (AT) hotmail (DOT) com> wrote:

FWIW if you open such a file in the Zeus IDE it will convert
all binary characters into spaces and tells you that it has
done so:

http://www.zeusedit.com

The converted file is marked as read only so if you want to keep
the changes then you just use the save as menu option.

Jussi Jumppanen
Author: Zeus for Windows IDE