"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:u3A0o2iIFHA.1304@TK2MSFTNGP10.phx.gbl...
> Ray
>
> Remember that lookups execute for EVERY row so you may be incurring a
> whole load of IO that may not be necessary. You do not say what syntax
> you have tried and any errors you have returned.
>
> Allan
>
> "RayAll" <RayAll@microsft.com> wrote in message news:RayAll@microsft.com:
>
>> Is it possible to call an insert stored procedure while I am transforming
>> records using Data pump task (in my activex).According to this example ,I
>> should be able to do it ,but It dosen't work for me.
>> http://www.databasejournal.com/features/mssql/article.php/1459171
>> Thanks
>

"RayAll" <RayAll@microsft.com> wrote in message
news:RayAll@microsft.com:

> Allan,
>
> Firstly I got it working. apparently when there is more than one paramter in
> Execute(0 method of a Lookup ,you must either remove parantheses or use the
> word **Call** in front of the lookup:
> Call ErrorLog (DTSLookups("Error_StatusLookup").Execute(1),1,55,"Unknown",5)
>
> Secondly : I kind of need to call stored procedure ,because I have to log
> the error that just occured in each row in a seperated table,I can use a
> simple insert into in my lookup,do you think it's better than calling stored
> procedure in my lookup?
>
> Thanks
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:u3A0o2iIFHA.1304@TK2MSFTNGP10.phx.gbl...
> > Ray
> >
> > Remember that lookups execute for EVERY row so you may be incurring a
> > whole load of IO that may not be necessary. You do not say what syntax
> > you have tried and any errors you have returned.
> >
> > Allan
> >
> > "RayAll" <RayAll@microsft.com> wrote in message news:RayAll@microsft.com:
> >
> >> Is it possible to call an insert stored procedure while I am transforming
> >> records using Data pump task (in my activex).According to this example ,I
> >> should be able to do it ,but It dosen't work for me.
> >> http://www.databasejournal.com/features/mssql/article.php/1459171
> >> Thanks
> >