Re: Execute Stored Procedure for ever record when importing?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gregor Anton (nospamplease_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 13:19:43 -0700

I've tried to do that but I get an error: The Query Designer does not
support the EXEC SQL construct.

My Query for the lookup is exec sysdba.GetKey NULL, PICKLIST, XXXX

"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:JNcGq9FJm2TAFwDb@sqldts.com...
> In message <uQgcvMsBEHA.3284@TK2MSFTNGP09.phx.gbl>, Gregor Anton
> <nospamplease@hotmail.com> writes
> >Is it possible to execute a stored procedure for every record when
> >importing?
> >
> >I have a table with a number of rows that need to imported into a table
that
> >requires a unique key, this unique key is generated via a stored
procedure.
> >So what I'd like to do is call this stored procedure, grab the return
value
> >and map it to the destination id field and map all other fields from the
> >import table to the destination table.
> >
> >Any suggestions?
> >
>
> Use an ActiveX Script Transform, and call a DTS Lookup.
>
> How to Use Lookups in DTS
> (http://www.sqldts.com/default.aspx?277)
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>

Relevant Pages

  • Re: Execute Stored Procedure for ever record when importing?
    ... >> I've tried to do that but I get an error: The Query Designer does not ... >> support the EXEC SQL construct. ... >> My Query for the lookup is exec sysdba.GetKey NULL, PICKLIST, ... >>> Use an ActiveX Script Transform, and call a DTS Lookup. ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute Stored Procedure for ever record when importing?
    ... > I've tried to do that but I get an error: The Query Designer does not ... > support the EXEC SQL construct. ... > My Query for the lookup is exec sysdba.GetKey NULL, PICKLIST, ... >> Use an ActiveX Script Transform, and call a DTS Lookup. ...
    (microsoft.public.sqlserver.dts)
  • Re: Using criteria in select query for recoding of variables
    ... The greatest book is probably the query designer, at least, for start. ... translator, when used to reach another field, here ToBe. ... You can take a look at the generated SQL. ... or Skill, is a field, and if a table is a junction table, it is often made ...
    (microsoft.public.access.queries)
  • Re: strange query error
    ... When I threw the SQL into Access' query designer, I got the error message on ... CurrCredit DECIMALNULL, ...
    (microsoft.public.access.queries)
  • Re: Using criteria in select query for recoding of variables
    ... find a way without the lookup table. ... The greatest book is probably the query designer, at least, for start. ... You can take a look at the generated SQL. ... or Skill, is a field, and if a table is a junction table, it is often made ...
    (microsoft.public.access.queries)