Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ssis dtsx package execution errors.

Posted on 2014-03-28
6
Medium Priority
?
480 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 29

Assisted Solution

by:becraig
becraig earned 1200 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 800 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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 1200 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

721 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