Use SQL2008 "import and export data" function, will be a SQL database table (there are more than 10000 data) into another SQL database, always make mistakes, errors are:

Is copied to the [dbo] [total table product purchase acceptance] (error)
Message
? Error 0 xc0202009: data flow task 1: SSIS error code DTS_E_OLEDBERROR, OLE DB error, error code: 0 x80004005,
Got OLE DB records, source: "the Microsoft OLE DB Provider for SQL Server" Hresult: 0 x80004005 description: "' (null) 'link Server OLE DB access interface' STREAM 'returned to the column' [! BulkInsert]. Brand name 'invalid data,",
(SQL Server to import and export wizard)
? Error 0 xc0209029: data flow task 1: SSIS DTS_E_INDUCEDTRANSFORMFAILUREONERROR error code, Destination "Input" Input "(161)" fails, an error code of 0 xc020907b, and in view of the "Input" Destination Input line "(161)" error handling Settings specified once error, failure, make mistakes on the object, specified in the specified components might have issued before this error message, provides detailed information about the failure,
(SQL Server to import and export wizard)
? Error 0 xc0047022: data flow task 1: SSIS DTS_E_PROCESSINPUTFAILED error code, process the Input Destination "Input" (161), the component "target - always table goods purchase acceptance" (148) ProcessInput method fails, an error code of 0 xc0209029, identification of the components from ProcessInput method returns an error, although this error is unique to this component, but it is fatal, will lead to stop running data flow task, probably before this has given an error message, provides detailed information about the failure,
(SQL Server to import and export wizard)
? Error 0 xc02020c4: data flow task 1: unable to add rows to the data flow task buffer, the error code of 0 xc0047020,
(SQL Server to import and export wizard)
? Error 0 xc0047038: data flow task 1: SSIS DTS_E_PRIMEOUTPUTFAILED error code, components "source - always table goods purchase acceptance" (1) PrimeOutput method returns the error code of 0 xc02020c4, pipeline engine calls PrimeOutput () when the component returns a failure code, although the failure code only related to the component, but this error is fatal, pipeline has stopped execution, might have issued before this error message, provides detailed information about the failure,
(SQL Server to import and export wizard)

Respect to computer expert advice, what is the reason? How to solve? Please guide, thank!

CodePudding user response:

What do you try the command import, select insert into the target table name field from the source table

CodePudding user response:

Access interface 'STREAM' returned to the column '[! BulkInsert]. Brand name' invalid data show that the current does not support BulkInsert STREAM, STREAM of view source table

CodePudding user response:

Most probably the source data do not match the database environment and target; If the source data table holds the STREAM data column point to a folder, but can't find the target table