DSXchange

I am trying to move a file BUSetup(1000001)20071119_200002.xml with the special characters ( ) inside the file name I am not able to do that Can anyone please let me know using which command I can remove those characters and rename the file or move the file I am doing this in the sequencer stage Tha...

Can anyone please let know why do get this error.

main_program: Failed to intialize job monitoring. Monitor information will not be generated.

[quote="prashkvrk"]Try this in the sequence: 1.In the user variable activity you must have given the job parameters definitions right? add one more varialbe such as inftctgtfiledate(interface target file date) and the give the value as "DSJobStartDate[1,4] : DSJobStartDate[6,2] : DSJo...

kausikMitra wrote:you can use unix command to rename the file ( u can use this `date +"%Y%m%d%H%M%S"`), use the command in "after job subroutine " in the job properties.

Can I send file as an attachment with the date from the email notification activity stage

use a job sequence with a job activity to invoke the parallel job,in the job activity,pass the value Convert('-','', DSJobStartDate) (if your data format is yyyy-mm-dd)to the job parameter,then use the job parameter as part of the file name,anyone has a better idea? yes, I am calling the parallel J...

JoshGeorge wrote:Pass current date ('-' stripped off) as parameter and use that parameter in file name.

ate

Just go and add in the job parameters :

param1= currentdate('-' stripped off) and call param while creating the file and send as an attachment in email.

Is that right ?

ArndW wrote:Do you want the timestamp to be part of the filename or part of the file contents? ...

Yes , like for example 20070725_test1.csv(only date)

I am extracting data from EDI format file and capturing some records
and generating a .CSV file. The business wants to generate the file each and everytime with date or timestamp ans send as an attachment with that date.

Is this possible to send as an attachment with the date?

Alternatively , if you are using a modify stage and if your input column ( from SQL server) is defined as timestamp; you can define the following modify stage specification( stage-Properties-Options, -> specification) : output_col:string[20] = string_from_timestamp["%mm/%dd/%yyyy %hh:%nn:%ss&q...

If you are converting to string it can convert format also. ... I donot have the problem with the SQL type .Both are varchar Where can I use the functions and change the format How to change the dates from 2007-06-18 01:00:07.000 (from SQL server database) to 5/4/2007 1:09:28 PM (source xml file) u...

You CANNOT change them in Lookup stage. Lookup stage does lookups. You must change upstream of Lookup stage, probably using Modify stage or Copy stage. ... I never used modify stage . I will try to change the format from this stage and get back to you if I have any questions Does this stage convert...

ray.wurlod wrote:You CANNOT change them in Lookup stage. Lookup stage does lookups.

You must change upstream of Lookup stage, probably using Modify stage or Copy stage. ...

I never used modify stage . I will try to chnage the format from this stage and get back to you if I have any questions

I am not quite sure of what you are doing, so I cannot answer directly. The lookup stage needs to match the source and target columns in order to work. In you case, what is the data type and format of the main data stream and what is the data type and format for the reference. Is the reference the ...

I would like to change the date from this format 2007-06-18 01:00:07.000 (from SQL server database) to 5/4/2007 1:09:28 PM (source xml file) Target is SQL server table I am using lookup stage and in the Lkp stage conditions I have given as condition not met : continue lkp failure: continue when i do...

I am using FTP eneterprise stage for the first time. I am not sure whether the path which I am giving is correct or wrong Error from dslog: FTP_Stage: uri : ftp://68.666.6.666/XXX_ftpdev/datastage_test/s/file.xml is having following ftp errors. In properties tab what should be in the connection: ftp...