Hallo Matthias, ich w�rde es �ber eine Linked-Server-Verbindung oder, besser noch, via DTS machen...
Gru� Michael KMU intelligence e.K. > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Matthias Dorfner > Gesendet: Mittwoch, 2. April 2003 15:40 > An: '[EMAIL PROTECTED]' > Betreff: [Database.asp] Bcp / Bulk insert > > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~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
