Treba da napunim podacima jednu tabelu. Problem je u tome sto mi MS SQLSERVER 2008 stalno izbacuje gresku. Napomenucu da sam prilikom punjenja koristio naredbu BULK INSERT, a datoteka iz koje je punjena tabela je .txt . Naravno, u toj datoteci sam podecio da mi kodni sistem bude "UNICODE 8" . Greska koju mi mssql server stalno izbacuje je sledeceg tipa:
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 8, column 4 (NacinPolaganja).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 9, column 4 (NacinPolaganja).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 10, column 4 (NacinPolaganja).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 11, column 4 (NacinPolaganja).
Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 12, column 4 (NacinPolaganja).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
Bulk insert naredba:
BULK INSERT NastavniPlanoviSt_PROBA from 'D:\Dokumenti\nastavniPlanovist.txt'
WITH
(
FIRSTROW = 2
)
Napomenucu da sam ubacio naredbu FIRSTROW = 2 zbog postojeceg zaglavlja u datoteci, a koje vi neceti videti u okacemon fajlu "NastavniPlanoviSt"
Moja tabela sadrzi sledece kolone i strane kljuceve:
CREATE TABLE [dbo].[NastavniPlanoviSt_PROBA](
[RbrNastavnogPl] [dbo].[RedniBroj] NOT NULL,
[RbrStavke] [dbo].[RedniBroj] NOT NULL,
[SifPredmeta] [dbo].[SifraCh6] NULL,
[NacinPolaganja] [dbo].[SifraCh2] NULL,
CONSTRAINT [PK_NastavniPlanoviSt_PROBAA] PRIMARY KEY CLUSTERED
(
[RbrNastavnogPl] ASC,
[RbrStavke] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] WITH NOCHECK ADD CONSTRAINT [FK_NastavniPlanoviSt_NaciniPolaganjaIspita_PROBAA] FOREIGN KEY([NacinPolaganja])
REFERENCES [dbo].[NaciniPolaganjaIspita] ([NacinPolaganja])
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] CHECK CONSTRAINT [FK_NastavniPlanoviSt_NaciniPolaganjaIspita_PROBAA]
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] WITH NOCHECK ADD CONSTRAINT [FK_NastavniPlanoviSt_NastavniPlanovi_PROBAA] FOREIGN KEY([RbrNastavnogPl])
REFERENCES [dbo].[NastavniPlanovi] ([RbrNastavnogPl])
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] CHECK CONSTRAINT [FK_NastavniPlanoviSt_NastavniPlanovi_PROBAA]
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] WITH NOCHECK ADD CONSTRAINT [FK_NastavniPlanoviSt_Predmeti_PROBAA] FOREIGN KEY([SifPredmeta])
REFERENCES [dbo].[Predmeti] ([SifPredmeta])
GO
ALTER TABLE [dbo].[NastavniPlanoviSt_PROBA] CHECK CONSTRAINT [FK_NastavniPlanoviSt_Predmeti_PROBAA]
GO
Ostavicu vam i notepad datoteku sa podacima kojima zelim da punim bazu.