Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhijaiswal.84
Starting Member
29 Posts |
 Posted - 2012-07-13 : 22:55:41
|
| Hi All,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.Thanks,AbhishekAbhishek |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-14 : 23:24:21
|
| whats the datatype of REGION? are you trying to apply some transformation over it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
abhijaiswal.84
Starting Member
29 Posts |
Posted - 2012-07-15 : 23:27:01
|
| 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.Abhishek |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-15 : 23:42:04
|
| and you're sure this is only error you get?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
abhijaiswal.84
Starting Member
29 Posts |
Posted - 2012-07-15 : 23:43:01
|
| Yes as I tried this is the only error I am getting...Abhishek |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-15 : 23:46:03
|
| did you try using OLEDB provider for Oracle instead?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
abhijaiswal.84
Starting Member
29 Posts |
Posted - 2012-07-15 : 23:50:28
|
| No I didnt....may be i will try that but as per company standered I have to use ADO.NET source as my senior recommendedAbhishek |
|
|
|
|
|
|
SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERR