DTS Load text to int 1

[hughed00]

I don't remember having problems with this before (good since I don't know how to do it!).

I have a text file source which is fixed length fields. The last field is a "number" representing length of a message.

When I setup DTS import using the wizard before, I seem to remember having no trouble designating the destination field to int even though it was importing text.

Now I get the error that the datatypes do not match and the import fails.

Do I need to add some code in the import for the conversion? Any idea why this is happening or a way around it (since I seem to have been able to magically do this conversion previously).

Thanx!!

 

[foxdev]

First, check your input file and make sure that each and every row has an entry (no blanks) for the problem column. I found this to be a problem, and when there is something there (even "0&quot, it works fine. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[harryrich]

Apparently DTS can import empty text data fields as blank instead of null. Apparently, blank text does not convert to numeric.

One alternative would be to supply your own DTS script for each numeric field allowing numerics to go through. dropping blanks, and flagging errors on text which is both non-blank and non-numeric.