Re: Global Variables and SQL Task

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Richard Highton (RichardHighton_at_discussions.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 07:54:01 -0700

No real reason why the MIG database is in quotes. I agree it works without them as well. I am migrating data into an oracle db. I had a problem setting the connection to the oracle db which I can't remember now. t8 should read t1.

"Allan Mitchell" wrote:

> Why is everything enclosed in "
> You are using 4 part naming so I presume you are going to a different
> server? Why? In the executeSQL task you simply create a connection for the
> MIG server
> What is T8? (set t2.act_key = t8.act_key)
>
>
>
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Richard Highton" <Richard Highton@discussions.microsoft.com> wrote in
> message news:D57490F5-A7F9-49F0-A0A5-66B0BD452A44@microsoft.com...
> > I have successfully set up several Transform data tasks which use a
> variable parameter in the where clause. However, when I try and use the same
> technique in an SQL Task, which is an update, I get an error - invalid
> object name 't2'. It works if I convert it to a select statment, but always
> fails as an update. I should add that the table I am updating is an oracle
> database. Has anyone got round this before?
> >
> > The code I am using is below:
> >
> > update t2
> > set t2.act_key = t8.act_key
> > from "MIG".."MIG"."SMXA" as t1
> > join "MIG".."MIG"."ORDERH" as t2 on t1.cc = t2.cc and t1.act_code =
> t2.act_code
> > where t2.sector = ?
>
>
>

Relevant Pages

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • RE: sunmanagers Digest, Vol 44, Issue 20
    ... diagnostics from the front-panel. ... Any ideas on what the problem may be or how to get this server powered ... The cluster itself is working, but I'm unable to shut down the nodes. ... Oracle uses shared memory for the communication between the client ...
    (SunManagers)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm writing for them. ... How do I get a free Oracle client installed, if possible, so I can test some SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)