January 15, 2016 at 1:54 pm
I have a Microsoft SQL 2000 server that I setup a DTS job to query an Intersystems Cache database and imports the results into a Microsoft SQL table. This job has been working for years. I am now in the process of recreating this job using a SSIS package on a new Microsoft SQL 2014 server. I have the destination database setup on the SQL 2014 server with the same column names and field lengths. When I run the SSIS package it errors out. The error is as follows.
SSIS package "c:\users\test\documents\visual studio 2013\projects\CDILab\CDILab\Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Error: 0xC020902A at Data Flow Task, ADO NET Source [2]: The "ADO NET Source" failed because truncation occurred, and the truncation row disposition on "ADO NET Source.Outputs[ADO NET Source Output].Columns[U_OrderName]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
Error: 0xC02090F5 at Data Flow Task, ADO NET Source [2]: The ADO NET Source was unable to process the data. Pipeline component has returned HRESULT error code 0xC020902A from a method call.
Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ADO NET Source returned error code 0xC02090F5. 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.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "c:\users\test\documents\visual studio 2013\projects\CDILab\CDILab\Package.dtsx" finished: Failure.
I am new to writing SSIS packages and I am unable to get past this error. I have the ADO Net Source setup and it connects to the Cache database. If I go to the connection manager for the source and do a preview of the SQL query it shows me the data. I go to the advanced editor on the OLE DB Destination and view the column mappings. The columns are mapped correctly. I also verified the datatype: Unicode string (dt_wstr) and length: 20 is the same on both the source and destination U_OrderName column.
Any help to resolve this would be appreciated.
Thanks,
Dave
January 16, 2016 at 6:37 am
The "ADO NET Source" failed because truncation occurred, and the truncation row disposition on "ADO NET Source.Outputs[ADO NET Source Output].Columns[U_OrderName]" specifies failure on truncation.
It says that there is a truncation error, where the destination column length is less than the source, can you check column U_OrderName
January 18, 2016 at 1:09 pm
er.mayankshukla (1/16/2016)
The "ADO NET Source" failed because truncation occurred, and the truncation row disposition on "ADO NET Source.Outputs[ADO NET Source Output].Columns[U_OrderName]" specifies failure on truncation.
It says that there is a truncation error, where the destination column length is less than the source, can you check column U_OrderName
I double-checked the column length. In Management Studio the column is shown as U_OrderName (nvarchar(20), null). When I edit the SISS package the Advanced Editor for ADO NET Source show the U_OrderName length as 20. The Advanced Editor for OLE DB destination shows the length as 20.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply