DSXchange

2000 might be more than allowed per column for an odbc handle maybe.

How many entries of "TransferDatabase" do you have in .odbc.ini file?

Search for it my friend. A quick exact search on key words 'Input buffer overrun at field' revealed this.

Look into surrogate key generator. Search the forums. It has been discussed before.

I thought 8.0 was for windoze. 8.0.1 was for the unix flavours

Its not because of the Date column and search would have revealed that. Please search on the error message. This is one such post on a similar issue.

Try setting the environment variable DS_ENABLE_RESERVED_CHAR_CONVERT to true.

Column names have '$' too huh. Well alias them as well, or too many columns that it can be a pain. I know there is an env. variable to set for special characters within passwords for oracle, dont know about column names.

Search the forum for validity tests. There is an IsValid() function that can help.

ray.wurlod wrote:Try "%dd-%mmm-%20yy"

Ray actually must have meant

Or even try with

Search on keywords "A numeric string was expected" .

Hey Kim, Whats "Mamu Kim" ? It means 'Uncle Kim' in certain languages.

You can always write an external program to do this. A shell script, a C program etc. which can be called from within datastage, which reads a flat file and does the median calculation for you.

I was thinking the same thing Craig. Finally we have a U

Thats because your not a premium member. Check here.