SSIS data transformation error in sql server 2005

Posted on 2011-10-27
Last Modified: 2012-05-12
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

Question by:blossompark
    1 Comment

    Accepted Solution

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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now