Citation

CREATE TABLE [VALEURS_CODIERS] (
[VCO_COD_ID] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[VCO_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[VCO_LIBELLE] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[VCO_LG_CODE] [numeric](6, 0) NULL ,
[VCO_ORDRE_AFF] [numeric](6, 0) NULL ,
[VCO_CMP] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_VALEURS_CODIERS] PRIMARY KEY CLUSTERED
(
[VCO_COD_ID],
[VCO_CODE]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [FK_COD_VCO] FOREIGN KEY
(
[VCO_COD_ID]
) REFERENCES [CODIERS] (
[COD_ID]
)
) ON [PRIMARY]
GO

Citation

-- Valeurs_codiers
SET @ls_NomTable = 'Valeurs_codiers'
SET @ls_DataFile = @is_DataPath + '\' + @ls_NomTable + '.TXT'
SET @ls_FmtFile = @is_FmtPath + '\' + @ls_NomTable + '.FMT'
SET @ls_SqlRequete = N'BULK INSERT d02.' + @ls_NomTable + N' FROM ''' + @ls_DataFile + N''' WITH (FORMATFILE=''' + @ls_FmtFile + N''' , MAXERRORS=1, CHECK_CONSTRAINTS)'
PRINT ' Lancement Chargement table '+ @ls_NomTable + ' le ' + convert(char(19), getdate(), 120)
EXEC sp_executesql @ls_SqlRequete
IF @@ERROR = 0
BEGIN
PRINT ' ' + @ls_NomTable + left(replicate('.',30),25-len(@ls_NomTable)) + 'OK'+ ' le :' + convert(char(19), getdate(), 120)
END
ELSE
BEGIN
PRINT ' ' + @ls_NomTable + left(replicate('.',30),25-len(@ls_NomTable)) + 'KO le : ' + convert(char(19), getdate(), 120)
GOTO ERREUR
END

B2000 a écrit

sur quels champs tu bloques ?