DSXchange

You have embedded newline characters in an unquoted field. You either need to get whoever is supplying you with this file to wrap that field in some kind of quote character, or figure out some othe ... Got the new file now with double quotes. Even then I could able to read only first line. I guess,...

Why in this world you want to keep headers, comments during processing? If you really want to do that, change it to varchar and then use IsValid() function to determine whether its a numeric value, if you find a numeric value apply conversion and your calculation else pass the value. Output should a...

In funnel, the number of input columns and data types should be similar in all links. How about using "varchar" instead of "decimal" for all the fields while reading? In data columns 10th column is calculation column which will be column 8 minus column 9. So, even if varchar. the...

Hi I have a requirement where I need to finally load data into a file Totally there are 10 columns First record will be some charecter record with all chars (SOME HEADINGS) second record will be with all chars (SOME NOTES) third record will be all char (COLUMN NAMES) All these above three records co...

Hi I have nine columns in .txt file with Pipe delimiter Say for example like this 100|01|00124938|Null|123456|Null|002|5|02/18/2010 14:12:26 By greg: Hello sir, I have ordered two items but one item was damaged at the shipping time: bla bla bla.. I could able to read first eight columns but last col...

Hi my source data is like for example KeyColNm Surrogatekey ------------ A .............10 A .............20 A .............30 A .............40 B .............10 B .............20 B .............30 C .............10 C .............20 C .............30 C .............40 C ............. 50 Means, lik...

Try this select * from personnel where id in ('#condition1#','#condition2#') when you want to put parameters in SQL, use the single quotes in SQL level but not in parameter so in parameter level condition1=1 (do not put quotes here) condition2=2 (do not put quotes here) Hi, My job uses query in a pa...

I am moving data from source FILE to targer FILE with some tranformations(like transformer, lookup etc) in between. due to that, some records will be dropped based on business reqm or during validations. Finally, when I am loading the data into file. The first record(which is control record), I have...