DSXchange

Hi Kumar, I think below commands would be helpful to remove header and trailer in unix. a= `wc -l filename.xml` # a is the total number of lines in that xml file b=`expr a - 3` # b is number of total lines minus 3 (trailer) head -b filename.xml > file1 #The above command will copy remove trailer lin...

Hi chaks,

you could also change the file (deleting the comma in unix) before Loop using execute command stage.

execute command---->Startloop<====>endloop

Easy way would be removing these two Header rows and tails row in unix using a shell script. ------------------------------------------------------------------------- #!/bin/ksh D=`head -1 FILENAME|tr -dc '[a-z]'` a=`cat FILENAME|wc -l` b=`expr $a - 3` c=`expr $a - 1` for [ i -eq $b ] do echo $D >>D...

Try this...

sed 's/[""]//g' oldFilename>Newfilename

I tested it and it should work

I missed [] in my previous post...

Try this...

sed 's/[""]//g' oldFilename>Newfilename

I missed [] in my previous post...

Use Stored Procedure stage and you have a option for SQL Server as one of the vendors, Try it...
Since your requirement has both input and output you cannot use ODBC stage.

Follow this Link

In stage Output>Format>Timestamp In Format String instead of %yy% use %2000yy%

You can use Stage variable...

initial Stage var i =0

i=i+inrowlink

your outputlink=i

Hi, please re-read my original post, I've already tried this. Did you give returnvalue(conditional)=1 or ='1' or = "1" ? I tried with returnvalue(conditional)=1...without quotes and it works fine. did you check your script file.. in error I see /sbin/sh your script should start with #!/bi...

Please try using option

Triggers > Expression Type > ReturnValue-(conditional)=1

instead of using custom-(conditional)

Please try using option

Triggers > Expression Type > ReturnValue-(conditional)=1

instead of using custom-(conditional)

[quote="jhorton"] I can get my stored procedure stage to connect to my SQL Server database but I am having troubles getting the arguments set up in the stage (I think).[/quote] How you got connect to SQL Server using Stored Proc stage ..? SQL Server is not supported in this stage. If you l...