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

SSIS data transformation error in sql server 2005

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

SUBSTRING
([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
OU=Remote,OU=Users,OU=Partners,DC=emea,DC=acme,DC=net,
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

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

)
0

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