• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 573
  • Last Modified:

SSIS data transformation error in sql server 2005

I'm using the following expression in the Derived Column Transformation Editor in SSIS

([AD Location],
FINDSTRING([AD Location],"OU=",1),
LEN([AD Location]) - ((FINDSTRING([AD Location],"DC=",3) + 6)) - (FINDSTRING([AD Location],"DC=",1)))

The expression is typically fed the following
the number of OU entries may vary....

What Iexpect  the code to do is return a string  such as "OU=Remote,OU=Users,OU=Partners" essentially stripping everything from the first "DC=" to  the end....
The code above parses ok but when I run the package I get  the following error;
[Derived Column [637]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component "Derived Column" (637)" failed because error code 0xC0049067 occurred, and the error row disposition on "output column "OU2" (826)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.

Any advice appreciated, thanks

1 Solution
blossomparkAuthor Commented:
this fixes it
[AD Location],
FINDSTRING([AD Location], "OU=", 1),
 (( FINDSTRING([AD Location], "DC=",1 )-1)


Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now