Error al Importar una tabla con el (SQL Server Import and Export Wizard)

Question

Post reply

Error al Importar una tabla con el (SQL Server Import and Export Wizard)

james_ibg_colombia

SSC Enthusiast

Points: 172
More actions
May 8, 2020 at 5:29 pm

#3750019

Hola a todos, mi nombre es james sabogal , soy nuevo en sql-server, pues en mi empresa trabajamos con informix.
En estos momento me encuentro en proceso de migrar datos de informix a sql-server.
Al intentar cargar una tabla desde informix, me genera los siguientes errores:
* Error 0xc020901c: Data Flow Task 1: There was an error with Source - gestion_cliente.Outputs[OLE DB Source Output].Columns[nombre]
* on Source - gestion_cliente.Outputs[OLE DB Source Output]. The column status returned was: "The value could not be converted because
* of a potential loss of data.".
(SQL Server Import and Export Wizard)
* Error 0xc0209029: Data Flow Task 1: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
* The "Source - gestion_cliente.Outputs[OLE DB Source Output].Columns[nombre]" failed because error code 0xC0209072 occurred,
* and the error row disposition on "Source - gestion_cliente.Outputs[OLE DB Source Output].Columns[nombre]" specifies failure on error.
* An error occurred on the specified object of the specified component.
* There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
* Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
* The PrimeOutput method on Source - gestion_cliente returned error code 0xC0209029.
* The component returned a failure code when the pipeline engine called PrimeOutput().
* The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
* There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
Agradezco si alguien me puede ayudar o guiar para solucionar este inconveniente.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 2

You would probably get a faster response if you did your own translation to English.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

jonathan.crawford SSCertifiable Points: 6612 More actions · Answer 3

Bueno, la única información que tenemos es que hay una "pérdida potencial de datos", tal vez el valor de origen es demasiado largo para el destino?

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses