[ srLooks @ 24.08.2011. 10:27 ] @
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. |