loveindia Posted July 22, 2015 Report Posted July 22, 2015 ooh avunaa... chustha repu open chesi.... Script ento assalu script script ani saava kodtunnav man... are you using c# script task or wat???
sandie Posted July 22, 2015 Report Posted July 22, 2015 script script ani saava kodtunnav man... are you using c# script task or wat??? SSIS code ni script antunna
loveindia Posted July 22, 2015 Report Posted July 22, 2015 SSIS code ni script antunna SSIS lo code undadu man... its all tasks drag and drop and configure them...
sandie Posted July 22, 2015 Report Posted July 22, 2015 SSIS lo code undadu man... its all tasks drag and drop and configure them... ooh GUI aa? cool... Aithe inka easy le.. will better learn... Sep varaku undhi deadline.
loveindia Posted July 22, 2015 Report Posted July 22, 2015 ooh GUI aa? cool... Aithe inka easy le.. will better learn... Sep varaku undhi deadline. needi em technology man...
loveindia Posted July 22, 2015 Report Posted July 22, 2015 beer_boy worked aa not worked aa tell man...
sandie Posted July 22, 2015 Report Posted July 22, 2015 needi em technology man... Informatica. kani working on reporting mothamm... edhi like chinna task.. oka project lo part time hours allocate chesadu manager..
loveindia Posted July 22, 2015 Report Posted July 22, 2015 Informatica. kani working on reporting mothamm... edhi like chinna task.. oka project lo part time hours allocate chesadu manager.. ok enjoy man...
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 (DT_STR,4,1252)(FiscalYear - 1) + " - " + RIGHT((DT_STR,4,1252)(FiscalYear),2) enjoy man.... I have tried this before error came, let me try this tommorow.
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 No dude work avatla..: fiscal year ni integer ga cast cheskoni substract cheyalemo... Coz string ni Ella substract chestam .... Your thoughts please
loveindia Posted July 22, 2015 Report Posted July 22, 2015 No dude work avatla..: fiscal year ni integer ga cast cheskoni substract cheyalemo... Coz string ni Ella substract chestam .... Your thoughts please So fiscal year field is a varchar field man??? I took it as an integer man.. aa mukka nenu adagakamundey nuvvu seppalaa.. nenu asalu adaganu aney kada nee feeling man.. give me like 10 mins..
loveindia Posted July 22, 2015 Report Posted July 22, 2015 (DT_STR,4,1252)(((DT_I4)FiscalYear) - 1) + " - " + RIGHT(FiscalYear,2) this is working fine man, provided that FiscalYear is a varchar field... I tried it on my system. See output FiscalYear FiscalYearNew 2015 2014 - 15 2014 2013 - 14 2013 2012 - 13
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 So fiscal year field is a varchar field man??? I took it as an integer man.. aa mukka nenu adagakamundey nuvvu seppalaa.. nenu asalu adaganu aney kada nee feeling man.. give me like 10 mins.. Clear ga chepalante....FISAL YEAR CHAR in source lo.... and destination lo nvarchar and madyalo trasformation vachesariki 2013-14 ani ravali source lo 2014 unte denini 2013 and -14 append cheyali.... emi chesina workout avatle chudataniki simplegane undi
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 (DT_STR,4,1252)(((DT_I4)FiscalYear) - 1) + " - " + RIGHT(FiscalYear,2) this is working fine man, provided that FiscalYear is a varchar field... I tried it on my system. See output FiscalYear FiscalYearNew 2015 2014 - 15 2014 2013 - 14 2013 2012 - 13 let me check this......workout ite superrr
Recommended Posts