Is i 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/featu...le.php/1459171
Thanks

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 (AT) microsft (DOT) com> wrote

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 (AT) no-spam (DOT) sqldts.com> wrote

There will be no difference really in either method.


"RayAll" <RayAll (AT) microsft (DOT) com> wrote