DSXchange

Hi all

I need to load the data into flat file as fixed width format,source is a sql server and am using runtime column propagation .But few of the columns in the target are Integer and timestamp.So if i use char data type for integer how much length should i give and for timestamp columns when i use char data type the job is getting aborted due to conversion problem.

So to generate the fixed width file please suggest me the approach.

Thank you

So just to be clear, you want to know how to generate a fixed-width file in an RCP enabled job, yes?

yes craig.....

For integers and timsestamp columns what datatype can be used.....

What happens when you stick with the original datatypes?

The problem is the integer column data is not all of same length.as am using RCP i cant transform any columns.and for timestamp columns there is no problem if there is null am populating space(26)

Schema file?

Yes am using schema file.The problem is with integer and timestamp columns for that how we can use to get fixed width format.

i have in the source Int(4).If i want to convert into char what length should i give.

It's an integer, the (4) just means it is stored in 4 bytes. Look up the maximum size of an integer and account for that.

craig

For the integer column having length of four .I queried in the database it has max length of data stored is six.so should i go for the char(6) or any logical conversion is required between integer(4) to determine the character length.

Forget the 4, it plays no role here. An integer can store a value up to 2147483647. However, if you are confident your value will never go over 999999 then use 6 for the length otherwise best to use 10 (or 11 if signed).