DSXchange

Hi all, There is a column with datatype date in table,we are creating csv file as target and when tried to open csv file the records in same columns displaying as (00:00.0)instead of (2004-03-01 12:00:00 AM). We have tried different ways by changing data type (Varchar, Date, Timestamp, Real, Nvharch...

Hi Craig,

So is there a work around for this issue, I did try just $ParamName and it too returns error, as expected.

Thanks,

Hi Craig,

So is there a work around for this issue, I did try just $ParamName and it too returns error, as expected.

Thanks,

Using DRS stage to read from oracle database table, in the sql the from clause is a job paramter. In the job paramter I have a environment varaible, and the job aborts saying invalid character, can we use a environment varaible in the job parameter? Here is the Job Paramter #FromClause# = prdtbl whe...

Hi Ray,

I checked that also . There are No spaces between the word Trim and its following left parenthesis.

Thanks,

Hi Ray, Still getting the error: JobControl (DSSendMail): Parameter 4 (',"@FM","A")') does not start with a keyword Unhandled failure (-19) encountered calling routine DSSendMail I even tried to use " around @FM in Trim(#CMD.$CommandOutput#,@FM,"A"). Also Ray, when...

Thanks for your inputs Ray, the issue stil persists! I have built a sample job where we have UserVariableStage--> ExecuteCommandStage--> NotificationStage In the ExecuteCommand stage if I use hostname, and in the email subject if I use #CMD.$CommandOutput# where CMD is the execute command stage name...

Thanks Ray,

I am using DSHostName , but it is giving me the value 'localhost' in the email!

I can use job parameters , but I wanted this to come from DS so that this job can be portable across projects.

Hi,
How do we add the DS Server name and the Project name to the e-mails (Email Subject Line) produced following job execution.

I have searched this forum and not found any posts.

thanks

Hi,

We tried Double Quotes and it Worked
Thanks

you should at lease write: (COL1='1' or (COL1='2' and COL2='#Param1#') or (COL1='3' and COL2='#Param2#')) and COL3='#Param3#' a apostroph ' before and after the param. Hi, Thanks , we did try that and get the same error! '(COL1='1' or (COL1='2' and COL2='#Param1#') or (COL1='3' and COL2='#Param2#')...

HI, We are facing an issue when we insert selection criteria in the SELECTION tab of Hashed file. The below is the select stmt (COL1='1' or (COL1='2' and COL2=#Param1#) or (COL1='3' and COL2=#Param2#)) and COL3=#Param3# Then it gives error when we select view data : DSD.UVOpen Retrieve: syntax error...