I am facing a problem while extracting data from ADO.NET source to SQL Server destination.
Below is the process I am doing and the error I am getting,
•In Microsoft SQL Server 2008, use the Microsoft ADO.NET Connection Manager and the Oracle Client data provider to create a new SQL Server 2008 Integration Services (SSIS) package. •added a data flow to the SSIS package. •added an ADO.NET data source to the data flow. •added an SQL command to the package. The SQL command queries a table in an Oracle database. •run the SSIS package.
After running the task I received below error massage,
" [ADO NET Source [16]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "ADO NET Source" (16)" failed because error code 0x80004003 occurred, and the error row disposition on "output column "REGION" (3453)" 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. "
Can anyone please help me on this front how can I remove this error and load the data successfully.
Datatype for Region is Varchar and I am not applying and Transformation. I dont think its the problem because of Datatype, even if we ignore the region feild the error goes to next column and so on.
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERR
Posted - 07/13/2012 : 22:55:41
