Hi,

I want to convert the following request using MSSqlIntput, tMap and tMSSqlOutput :


UPDATE CRM_COORD
SET CRM_COORD.ID_CRM = Z_CRM_DEDUP_XXX.ID_CRM
FROM CRM_COORD,Z_CRM_DEDUP_XXX
WHERE CRM_COORD.ID_CRM = -1 AND CRM_COORD.CD_SOURCE = 'DOL'
AND CRM_COORD.ID_SOURCE = Z_CRM_DEDUP_XXX.ID_SOURCE


I have succeeded using a tMSSqlRow (see screenshots) but I'd prefer to use a tMSSqlOutput

Here are the create statement of table CRM_COORD and Z_CRM_DEDUP_XXX

CREATE TABLE [dbo].[Z_CRM_DEDUP_XXX](
    [ID] [int] NULL,
    [ID_CRM] [int] NOT NULL,
    [CD_SOURCE] [char](3) NOT NULL,
    [ID_SOURCE] [int] NULL,
    [email][varchar](128) NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[CRM_COORD](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [ID_CRM] [int] NOT NULL,
    [CD_SOURCE] [char](3) NOT NULL,
    [ID_SOURCE] [int] NOT NULL,
    [CD_MARQUE] [char](3) NULL,
    [ADR1] [varchar](50) NULL,
    [ADR2] [varchar](50) NULL,
    [ADR3] [varchar](50) NULL,
    [ADR4] [varchar](50) NULL,
    [CP] [varchar](10) NULL,
    [VILLE] [varchar](50) NULL,
    [PAYS] [varchar](50) NULL,
    [TEL] [varchar](20) NULL,
    [MOB] [varchar](20) NULL,
    [FAX] [varchar](20) NULL,
    [email][varchar](128) NULL,
    [IS_DELETED] [bit] NULL,
    [ID_DOMAINE] [smallint] NULL,
    [IS_DOMAINE_PERSONNEL] [char](1) NULL,
CONSTRAINT [PK_CRM_COORD] PRIMARY KEY CLUSTERED
(
    [ID_CRM] ASC,
    [CD_SOURCE] ASC,
    [ID_SOURCE] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
CONSTRAINT [IX_CRM_COORD] UNIQUE NONCLUSTERED
(
    [ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]


thanks for your help,
Didier

Last edited by dchambon (2012-05-04 11:06:49)