Hallo Leute, ich m�chte aus einem SQL Server 6.5 2 Tabellen rauskopieren und in einen SQL server 2000 einf�gen.. das m�sste ja mit bcp gehen? Ich bekomm auch sch�ne txt files nach dem exporten.
beim importen mit der query bulk insert bekomme ich immer folgende fehlermeldungen: Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 1, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 2, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 3, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 4, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 5, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 6, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 7, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 8, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 9, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 10, column 1 (test). Server: Msg 4863, Level 16, State 1, Line 1 Bulk insert data conversion error (truncation) for row 11, column 1 (test). Server: Msg 4865, Level 16, State 1, Line 1 Could not bulk insert because the maximum number of errors (10) was exceeded. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated. was mache ich da falsch? Tipps oder anregungen wie's leichter gehen k�nnte? Danke Matthias ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
