DSXchange

Is the "First Line is Column Names" property set to True? This does need to be explicitly set - it does not import with the other format information, because it is a stage property whereas the other ... Thanks for the quick response ray.. I have set the "First Line Column Names"...

Hi All :) I have to read a sequential file(records r comma seperated), apply transformation and insert data into dataset.I am specifying Metadata for col1 as char(6) and col2 as varchar(30).Input Data is as follows(First Line is Col. name) statecode,statefullnametext ACT,Australian Capital Territory...

Can you post the exact derivation from the Transformer stage you have used? It should be StringToDate(InputLink.Column, "%yyyy%mm%dd") Thanks for quick response..."Kris007" I used the following derivation StringToDate(DDate [1,4] : "-" : DDate [5,2] :"-" : DD...

Hi :) , I am getting Following warning while converting data in string format to date Transformer :Conversion error calling conversion routine date_from_string data may be lost The String Length is 8(e.g. 20341221),and I used the StingToDate function and got the output 2034-12-21 but with warnings.....

Hi , what would be the expected output if i try to read a string say "1024" using datatype decimal[4,2] in a sequential file ? also what will be the output if the string is 10. Please reply , I dont have an environment to check these things. :) Thanks Hi Abhi... The Expected output is 102...

Thanks all of u for the Information....
Can u also specify where can i get additional information about these minute details

Can anyOne Explain ..why it is so that you should import table definitions by Orchestrate Schema Definition in Parallel Framework and
not using definitions imported via ODBC