DSXchange

You will find in "Sum Output Column" with the property name "Decimal Output" where the default is 8,2 .

Also Remove the stage and re design with the same stage as the stage might got corrupted. if u build it again it might solve the issue.

Change all the Char datatype to Varchar and re run the job. It worked for me.

I just mapped the internal ds format to sql server and checked whether it works or not- it worked with out any issues.. My Source is YYYY-MM-DD, for all my transformation i have to convert it to internal ds format and while loading into sql server ( Date - datatype) .. just map the internal ds forma...

Yes.. I could convert .. My target data type is date.

I have used ICONV(input.date,"D-YMD[4,2,2]") to convert it to internal format. this output number has to be inserted into sql server.

Hello All,

I am trying to convert the internal format to SQL Server Date format. It is unable to convert and inserting NULLS - which i cannot.

Help Appreciated.

Hello, Input file comes as follows. 1,STREET,ABC 1,ADD1, 1,ADD2,00 1,CITY,NYC 1,STATE,NY 1,COUNTRY,US 2,STREET,blvd 2,ADD1,1234 2,ADD2,add2 2,CITY,NW 2,STATE,NJ 3,STREET, 3,ADD1,new1 3,CITY,PHIL 3,STATE,PA 3,COUNTRY,US Output file should look like this Output Column Names: NO,STREET,ADD1,ADD2,CITY,S...

Thanks a lot ray. It worked.

I couldn't see the full content. Can you allow to watch the premium content.

There is a situation where i need to allow only alpha, numeric and a hyphen in a particular column . If i found out any other character i have to reject the entire record.

how to acheive this.. Need help on this.

Use After Job Subroutine DSSendMail to send an email and attach the rejected file in the job itself.

I think its better to go with a shell script.It gives you more flexibility.

can you guide me in using thru execute command stage...

hello,

how to insert a sleep command in sequencers.
help appreciated...