DSXchange

Thanks bala,
I too have gone through the sql book...didn't understand
Could You plz eloborate....
With out inserting(mapping) how will it populate to the table?
Regards,
Via

Hello folks, After 3 days of work with all the iconv,oconv and other procedure, here i found a way to convert my cyynnn and hhmmss sources in to a string. Left side are stage variables in the transformer with datatypes. (varchar)y2d= TrimLeadingTrailing(IN.Date[3,2]) (integer)y4d= '20':y2d (varchar)...

But the date is in cyynnn format
c:century
yy:year
nnn: day number
My initial problem itself is to conver this cyynnn to the ordinary date.
Thanks any way,
Via

Thanks Amey Vaidya and Carter for your input,
I am working on this, let me find out how it turnout.
Thanks again,
Via

Thank you Ray,
But cyynnn is some thing unique that i am unable to resolve. Could you please suggest how to hold the c value in cyynnn format to yyyy-mm-dd using the same iconv and oconv?

Thanks again,
Via

Hello, I made a search for converting julian date to yyyy-mm-dd : hh-mm-ss. I tryed the following in the transformer stage variables as var1=Oconv(Iconv(TheDate, "D4YJ"), "D/YMD[2,2,4]") var2 =Oconv(Iconv(TheTime, "MTS"), "MTS:") And i tryed concatination in t...

Hello,
I tryed moving jobs from one catogory to another with Manager, director & designer! Either of them allowed me to move the jobs. Hacking! fear of corrupting the repository. Any other tip moving the jobs?
Via

Thanks naveen and other folks, thanks

Hello every one thanks for the reply, I manually typed in all the Userdef environmetal variables for the new project i imported. Even after doing this i see OLD parameters in the "JOBS" that are pointing to the old DNS,passwords,users...etc . Even if i change to the new one there in the jo...

Thanks chulett.
Even before seeing your post, I retyped all the env variables in the new project .
Thanks again
Via

Thanks for all,
I am done with the project export and new project import. Now i missed all Environment variables in the new project. Is there some thing i am missing to do for importing the Environment variables while doing whole project import?
Thank
Via

Thanks,
But how to export to that particular new project? By default it is taking the same name that it took to make .dsx file
Thanks again
Via

Hello every one, We have the same situvation. We have a project in production. We want to make some changes to the production, so i exported the whole project to Devolopment area. After changes i want to export back to producation. The isuue is can i have a different name to the one i made changes i...