DSXchange

Aasif, are you trying to use output from Stored Proc 1 as input for Stored Proc 2?

Have you tried @outrownum=1 as a constratint in the transformer??

Or you could start with a row generator stage. Set number of rows to produce to 1 and define your columns same as your input parameter.

so your job design will be like

row generator--------------->SP Stage----------------------->Output

Or you could start with a row generator stage. Set number of rows to produce to 1 and define your columns same as your input parameter.

so your job design will be like

row generator--------------->SP Stage----------------------->Output

Sorry about the confusion. Let me explain my plan of action. I thought as I already have the output as 1,name1,name2,name3 2,name1,name2 3,name1,name2,name3,name4 I could read each row as one long fixed width and pad the remaining character with null. Say for example after name3 for 1st row, after n...

Hi Ray, I assume from your previous post that I have to read the data as a long fixed length data. Each column is 100 characters long so for 500 columns it will be 500*100. Now the problem is lets say after 200 columns my data is padded with null. Even then after every 100 character column import st...

Thanks Ray. I am not supposed to use server jobs. So let us say the max number of columns I can have is 500. After the transformer stage in my job design my output would be like follows. 1 name1 name2...........name500. But for this month let say I only have 200 columns. How to pad the rest 300 with...

True, the vertical pivot has been discussed many times before. But nothing concrete for vertical pivot for changing number of input. Has anybody implemented this?

Hi everyone, I need some help to apply vertical pivot logic for dynamic data. I have achieved the vertical pivot and the data output is correct but now the business rule has changed and I will not have constant number of columns. Below is my job design. Input Data Key_Col Data_Col 1 name1 1 name2 1 ...