Derived column failures due to error codes DTS_E_INDUCEDTRANSFORMFAILUREONERROR 0xC0049067 and DTS_E_PROCESSINPUTFAILED 0xC0209029
-
Hi All,
I've been working on an SSIS package for which I've added derived columns (which I've posted earlier on here). The issue I'm running into is that this child package is running fine in one environment, but for some reason, is failing in my Dev environment. The errors occurring are: "SSISError Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DerivedColumn" (9567)" failed because error code 0xC0049067 occurred, and the error row disposition on "output column "SchemaID"(9744)" specifies failure on error" and "SSISError Code DTS_E_PROCESSINPUTFAILED. TheProcessInput method on component "Derived Column" (9567) failed with error code 0xC0209029 while processing input "Derived Column Input"(9568). The identified component returned an error from the ProcessInputmethod". I've compared the table's fields, particularly SchemaID in both environments and they're identical. I even tried recreating the particular table in Dev and re-tried running the package, to no avail.
This is the Derived Column Tranformation Editor screen:
Can anyone please make any suggestions on this? Thank you in advance!
-
Sounds like a data issue in DEV where one of the functions you are using, likely FINDSTRING is not returning a value > 3 so the -3 is causing a negative value for the length parameter of SUBSTRING which is invalid. I'd duplicate the code in SQL and see if I get a result with an invalid length provided to substring error.
You could use an IF in the Length parameter of substring where if FINDSTRING returns <= 3 you use LEN(column) - 3 or something similar that meets your requirements.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Thanks for your input, Jack. The issue has since subsided, but I'll keep your suggestion in mind in case it resurfaces 🙂.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply