January 22, 2016 at 9:11 am
Hi,
I am trying to bring in two fields from a SQL database (Comments,Description) stored as varchar(MAX) NULL . My destination table also has the same data type.
I am using ADO.NET Destination . When I compare mappings between Input and output columns in the ADO.NET Destination Editor, the input is coming in as DT_NTEXT and output as DT_WSTR . When I run the package , it breaks only for these two fields.
Please help how I can resolve this issue .
Thanks,
PSB
January 22, 2016 at 9:51 am
PSB (1/22/2016)
Hi,I am trying to bring in two fields from a SQL database (Comments,Description) stored as varchar(MAX) NULL . My destination table also has the same data type.
I am using ADO.NET Destination . When I compare mappings between Input and output columns in the ADO.NET Destination Editor, the input is coming in as DT_NTEXT and output as DT_WSTR . When I run the package , it breaks only for these two fields.
Please help how I can resolve this issue .
Thanks,
PSB
What does 'it breaks' mean? You've been here long enough to know that you should post error messages.
I presume that you've tried using the data conversion component to fix the problem, so what happened when you did that?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 22, 2016 at 10:05 am
I have used a data conversion task and converted to DT_TEXT and then mapped it back to the destination. However the error still persists.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (2) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (9). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
January 22, 2016 at 10:45 am
PSB (1/22/2016)
I have used a data conversion task and converted to DT_TEXT and then mapped it back to the destination. However the error still persists.[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (2) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (9). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
[ADO NET Destination [2]] Error: An exception has occurred during data insertion, the message returned from the provider is: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Which part of this error message makes you think that this is a data type issue?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 22, 2016 at 11:02 am
Although the message is not clear, the error is because of these two fields.
When I comment out these fields in the source query, the package runs fine.
January 22, 2016 at 11:13 am
PSB (1/22/2016)
Although the message is not clear, the error is because of these two fields.When I comment out these fields in the source query, the package runs fine.
OK, but could it be that there is a huge amount of data in these columns which really is causing a timeout?
Have you tried with just a small selection of data (eg, select top 5 ... ) to see whether that works?
If it does, volume of data is the next thing to look at.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply