Re: DTS Update or Insert

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 13:01:06 -0000

If the statement is issued fine and syntactically it is fine then

Do the two tables have the same values in those same attributes already?
Have you checked using a SELECT to see which rows should be being updated? 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Bryan Harrington" <news@psacake.com> wrote in message
news:OhYTbMZEEHA.3784@TK2MSFTNGP10.phx.gbl...
> Hello.. I'm building an interface of sorts, taking account data from a
daily
> dump to a text file, sucking it into a temp table (Interface_Accounts)..
> that's not a problem.
>
> Once it is in the temp table, I need to then either Update the Accounts
> table (if the account number already exists in the accounts table), else
> Insert a new record.  The update does not happen. The account balance is
not
> changed.
>
> The SQL I have is as follows:
>
> UPDATE Accounts
> SET accounts.account_balance = interface_accounts.account_balance,
> accounts.service_date = interface_accounts.service_date
> FROM Accounts  JOIN Interface_Accounts  ON accounts.account_number =
> interface_accounts.account_number
>
> It parses fine, SQL says it's ok, but no updates happen. I know for a fact
> that data has changed.  Any thoughts?
>
> Thanks!
>
>

Relevant Pages

  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql server 2005 clustered service group
    ... For each clustered service in the instance of SQL Server that you are ... administrator for the names of existing domain groups, ... Note that SQL Server accounts will not be removed from the groups if SQL ... I see with installing SS2005 cluster if forces me to use domain accounts ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain Groups For Clustering Service ???? SQL Server 2005
    ... You need to manually add the service accounts you specify during setup into ... services then just add that to each of the 3 domain groups you create. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Backup on Network
    ... The correct permissions will be set if using Enterprise ... Manager to change the service accounts. ... Change the SQL Server or SQL Server Agent Service ... >> Also we have given FULL CONTROL rights to the target directory. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie question on SQL connection
    ... Let me educate you about SQL Server security. ... The "Trusted Connection" error is associated with the "Windows ... granting permissions to these accounts in SQL ...
    (microsoft.public.dotnet.framework.aspnet)