DSXchange

Buddy, try with Len() function to get the exact lengths. Only then you can check with the target metadata. Otherwise it will be very tedious. You might get lucky and spot the culprit column(s) or it might take you forever. Thats why try with the Len() function.

Thats the problem with excel sheets. If nothing is entered in the column, while the export to csv, you wont see the last column. Try with different setting of "Incomplete Column" for the last column in the column's tab of the sequntial file stage. That should do the trick.

Well, then you need to look at 3rd year's data and see which column's data is going beyond its definition. Do a spot check on the data, if you see any data going beyond its definition thats the culprit. If the number of columns are large, then source your file, put in a Len() function to get the len...

Just a shot in the dark, try

Well aparantly, you missed a column or two. Since your source is a flat file, its hard to say what the maximum length can be. You will have to put in a LEN() function to get the length of each and every column. Inspect to get the max of all the lengths that you got and then compare that with your ta...

Mouthou, you dont have to quote the entire message. It makes for poor readability and clogs up the posts.

Delete the entry and retype it again. Save the file and then try again.

How many maximum concatenated running numbers can you have? If you have a max then you can generate the extra rows. Do a simple lookup and you will automatically get a hit on the hashed file with the key you want.

Aww, thats sweet Mamu Kim. Guess, I'll start calling you that as well

MAXKEYSIZE in uvconfig file has a limit of 768 but its not connected so dont change that limit. Maybe someone here can shed some light on this behaviour.

Please do an exact search on "Unrecognized top level format property" for related posts.

Your data and meta data does'nt match. Search for more related posts. One is here

Make sure the DSN name is identical inside your job and in the .odbc.ini file. Thats the only other thing that could be wrong. Make sure there are no leading trailing spaces. They should be identical.

What is the length of the entire record with your desc column set to 666?

O ok. Thanks for the clarification.