Reference a Lookup task from within a Script Component

Posted on 2011-10-06
Last Modified: 2013-11-10

I am in the process of converting a DTS package into SSIS.  That DTS package has an ActiveX script that references a DTS Lookup.  The code looks something like the following:

myid = DTSLookups("GetSomeId").Execute("DTSSource(variable1, variable2)

Is it possible to have the Script Component reference a lookup task?

Question by:yechan
    LVL 21

    Accepted Solution

    Why would you do that anyway ?!

    I found this article talking about lookup inside a script component...check it it would help
    LVL 1

    Author Comment

    I am not married to the idea of embedding a lookup task inside the script component.  Trying to "upgrade" an existing DTS package to SSIS.  If you think there is a better way, please let me know.

    LVL 30

    Expert Comment

    by:Reza Rad
    what are you doing in this lookup, does your requirement accomplished by regular LOOKUP TRANSFORM in the SSIS Data Flow toolbox?
    if this doesn't make sense to you, could you tell us samples of your input data rows and your desired output result, and we could help you better
    LVL 1

    Author Comment


    i have replaced the DTSLookup with a SQL query call.  Wish I had more time to get this done right =)


    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 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