<div>
I am not married to the idea of embedding a lookup task inside the script component. &nbsp;Trying to &quot;upgrade&quot; an existing DTS package to SSIS. &nbsp;If you think there is a better way, please let me know.<br />
<br />
thanks<br />

</div>


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.

thanks


<div>
what are you doing in this lookup, does your requirement accomplished by regular LOOKUP TRANSFORM in the SSIS Data Flow toolbox?<br />
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
</div>


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

<div>
all, <br />
<br />
i have replaced the DTSLookup with a SQL query call. &nbsp;Wish I had more time to get this done right =)<br />
<br />
thanks<br />

</div>


all,

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

thanks


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am in the process of converting a DTS package into SSIS. &nbsp;That DTS package has an ActiveX script that references a DTS Lookup. &nbsp;The code looks something like the following:<br />
<br />
myid = DTSLookups(&quot;GetSomeId&quot;).Ex<wbr />ecute(&quot;DTS<wbr />Source(var<wbr />iable1, variable2)<br />
<br />
Is it possible to have the Script Component reference a lookup task?<br />
<br />
thanks
</div>
</div>


Hi,

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?

thanks

Reference a Lookup task from within a Script Component

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.