Solved

ssis dtsx package execution errors.

Posted on 2014-03-28
6
463 Views
Last Modified: 2016-02-10
I have created a ssis dtsx package which seemed to go fine until I execute the package. Below is an excerpt from the "Execution Results" tab. Could somebody tell me why this is blowing up and what I can do about that?
Thanks in advance.

[SSIS.Pipeline] Information: Execute phase is beginning.

error msg - [Source - DXX_ENCOMPASS_OND_MAIL_140327_txt [1]] Error: Data conversion failed. The data conversion for column "Column 94" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

error msg - [Source - DXX_ENCOMPASS_OND_MAIL_140327_txt [1]] Error: The "output column "Column 94" (386)" failed because truncation occurred, and the truncation row disposition on "output column "Column 94" (386)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

error msg - [Source - DXX_ENCOMPASS_OND_MAIL_140327_txt [1]] Error: An error occurred while processing file "C:\Documents and Settings\sritsick\My Documents\jsr\Erie_Master\test\Scott\DXX_ENCOMPASS_OND_MAIL_140327.txt" on data row 1.

error msg - [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - DXX_ENCOMPASS_OND_MAIL_140327_txt" (1) returned error code 0xC0202092.  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.

[SSIS.Pipeline] Information: Post Execute phase is beginning.
0
Comment
Question by:tesla764
  • 3
  • 2
6 Comments
 
LVL 29

Assisted Solution

by:becraig
becraig earned 300 total points
ID: 39962553
This seems to be a dataflow issue between source and destination.

What type of file are you importing from ?


Please do a quick spot check of your mappings between source and destination



      Try adjusting the source data types in the Advanced tab, update data type of any bad columns from DT_TEXT.
0
 

Author Comment

by:tesla764
ID: 39962600
I am importing from a .txt file.
I will try your suggestions in a minute.
Thanks.
0
 
LVL 9

Accepted Solution

by:
edtechdba earned 200 total points
ID: 39962601
This error appears to be pointing to a data column truncation issue. Trying to push in a data value greater in length than what can be accepted on the receiving side. Do you know which column is "Column 94"? That may point you in the right direction.

In this circumstance, I would check out the mapping within the destination task (of the data flow task), hover over each source column and destination column and verify that both data field lengths match.

If there is a mismatch, you can right click on the source task, click on advanced and then update the output column length to match the destination task length. Or vice versa, increase your destination column to match the source column length.

Another option (if you are able to pinpoint the column that is the issue), is to create another task in-between the source and destination (data conversion task I think) and truncate the value from the column before it's pushed into the destination task.

I hope that helps!
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:tesla764
ID: 39962610
The input data types are DT-STR.
0
 

Author Comment

by:tesla764
ID: 39962613
edtechdba I will try your suggestion in a few minutes. Thanks.
0
 
LVL 29

Assisted Solution

by:becraig
becraig earned 300 total points
ID: 39962620
Change the input type to DT_TEXT and try again.

For the problematic column it might be safe to set the destination to nvarchar
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now