DSXchange

The files names are all different so I am using specific files.

Please advice

Thanks for the suggestions

I am trying to read multiple files from a sequential file stage.If I try to read one file at one time I can view the data.But If I specify read method to Specific File(s) and read all the files then aso I can view the data for all the files but I find a special charater at the beginning of the file ...

I am writing a logic in the Transformer.This logic gives me the expected results. But my Performance goes down with this logic in the transformer.Please help me in writing a better logic than this. if col1= '8000' OR col1 ='8100' OR col1 ='8300' OR col1='8301' OR col1='8302' OR col1='8400' OR col1='...

Thanks for the information ................Ray.

I am sorry I forgot to mention that when extracting data from table I am writing a User-defined query.select max(col1) from table. I played around by taking out max(col1) and just extract select col1 from table. I dont get that warning.but if I give select max(col1) from table then I get the warning...

record {final_delim=end, record_delim='\n', delim=',', quote=double} ( Col1:int16 {quote=none}; Col2:string[max=20] {prefix=2}; Col3:string[max=15] {prefix=2}; ) This is the record schema of the source which is SQL table.I am taking only Col1 to target and writing it to a sequential file.I defined t...

SQL_Process_Run_Control: When checking operator: When binding output interface field "Col1" to field "Col1": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.

I have 5 columns in a table. I am taking only one column from the table and writing it to a Seq file.This is Parallel job. and the column is not nullable.The column is set is not nullable in the Target i.e the sequential file.it is a simple load from a table to a file.I am getting the following warn...

I have a source (Flatfile). I am copying the data from source to a SQL server table.The datatypes in source are Varchar and in Target they are Nvarchar an Decimals.where ever there is a decimal I used stringTodecimal conversion. The job gets aborted with the following error. SQLServer_Enterprise: [M...

That doesn't work too

I did use the funnel stage but I dont get the records in the expected way.I get all 10's together and 20's together.

Yes I want to select rows alternately from each of the two source files. there are no constraints included and the source files guaranteed to have the same number of rows as the other.The two sources have same number of records.I want to collect one record from each of the file alternately like the ...

Yes I want to select rows alternately from each of the two source files. there are no constraints included and the source files guaranteed to have the same number of rows as the other.The two sources have same number of records.I want to collect one record from each of the file alternately like the ...

I have 2 sequential files each file has 100 records and I am writing it to a sequential file.This file will have 200 records. Seq file 1 has records Col1 col2 col3 ........col n 10 .... .... ...... 10 .... .... ...... 10 .... .... ...... 10 .... .... ...... Seq file2 has records Col1 col2 col3 ........