DSXchange

Thank you so much.

Can you help me with another doubt.

the post name is "columns not propagating"

the environmental varialble is pointing to a directory where the source is data file is placed now the source data file is in another directory.... so which environmental variable shoould i be changing inorder to make that change this Environmental varaible is only for a this particular job thanks a...

Sorry But I could not understand much out of what you said... if we go to job parameters in job properties.... we have an add environmental variable button where in we have all the general, customised, parallel, user defined one.... so which one of those environmental varialbles i should be changing...

Source is spreadsheet in a sequential file there are 6 tabs in one single spreadshheet two tabs are joined as one in a sequential file ... like that 3sequential files are made.. these 3 seq files are joined using join stage and then written to a sequential file ..... It worked perfectly and data cou...

How to change the Environmental variable in Parallel job

If it is pointing to a certain folder then how do we change it to point to another folder

where should we change....and what should we change?

thanks
aschand

Now there are no compilation errors but the data is not getting into the target

Thanks
Srichandana

I just drag the respective columns from source to target.... varchar in source to Nvarchar in target got changed automatically... no complilation errors But when i run the data is getting processed... and one morething is when i right click the transformer i cannot see the target link name that is p...

Yes... Before i had erros while compiling saying Implicit conversion from string to Ustring... and so... but now there no errors... the target is the table in SQL Server and the source is Spread sheet in Sequential file the data is not getting processed from source to target... i can view the data i...

Can any one please tell me what to be placed in these string and mapname


StringToUString(%string%,[%mapname%])


thank you

HI the columns are not propagating ... everything seems to be OK.... other than datatype mismatch... where in source has varchar(255) and target has Nvarchar(50) please can any one let me know this and if it is the problem then what fuction should i be using to convert varchar to Nvarchar ? or where...

can you please put it as normal content instead of premium content please

and can you be more specific... by giving exact derivation

thanks
aschand

Sorry I dint mean to say its urgent though it is... it was by accident i had attached the signature that i wrote for the first time... If in source file..... abc varchar 255 target table ........ abc Nvarchar 50 Now how do I link one to the other by converting source datatype and its length into tar...

Can anyone please tell how to write in the derivation when we have to convert

1. varchar to nvarchar
2. integer to decimal
3. string to decimal
4.string to Ustring
5. ustring to decimal

where first one is source and second is target

Thank you so much

I did so just with SetNull()....

but i dint get clear picture of the datattypes... how do you think they should be done?

Can you please give me an example in the derivation

But I got these errors while transforming ##W IIS-DSEE-TFEV-00023 00:29:42(093) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString". ##W IIS-DSEE-TFEV-00025 00:29:42(094) <transform> Error when checking compos...