loveindia Posted July 22, 2015 Report Posted July 22, 2015 mayya nak sepu eesari pakka join aitha nen... marchipok mayyyo done deal man...
ipaddress0 Posted July 22, 2015 Report Posted July 22, 2015 done deal man...mayya gatlane mana kothi fafa bhi class ki oche laga sudu... iga nen rechipotha :P
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 where is this beer_boy man?? Maaya.....but destination fail avthundi because of that conversion column..... ...errors post chesta man.... faaaking ekadooo doing mistake..
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 [OLE DB Destination [248]] Error: There was an error with input column "FISCAL_YEAR" (657) on input "OLE DB Destination Input" (261). The column status returned was: "The value could not be converted because of a potential loss of data.".
superted Posted July 22, 2015 Report Posted July 22, 2015 [OLE DB Destination [248]] Error: There was an error with input column "FISCAL_YEAR" (657) on input "OLE DB Destination Input" (261). The column status returned was: "The value could not be converted because of a potential loss of data.". tagadam manesi pani cheyi ani mtkr antunadu
mtkr Posted July 22, 2015 Report Posted July 22, 2015 [OLE DB Destination [248]] Error: There was an error with input column "FISCAL_YEAR" (657) on input "OLE DB Destination Input" (261). The column status returned was: "The value could not be converted because of a potential loss of data.". (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 this shld wrk myann
mtkr Posted July 22, 2015 Report Posted July 22, 2015 tagadam manesi pani cheyi ani mtkr antunadu :3D_Smiles_38: :5_2_108:
loveindia Posted July 22, 2015 Report Posted July 22, 2015 Man, what does the Metadata tell you about fiscal_year field from source before you connect to derived column?
loveindia Posted July 22, 2015 Report Posted July 22, 2015 simple solution is, just remove the data source in the package and add it again man... it should work... may be it saved the metadata and throwing an exception... try this and tell....
Pandu_age40 Posted July 22, 2015 Author Report Posted July 22, 2015 simple solution is, just remove the data source in the package and add it again man... it should work... may be it saved the metadata and throwing an exception... try this and tell.... trying the same ..... #/{-
Recommended Posts