Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • Last Modified:

ssis dtsx package execution errors.

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
tesla764
Asked:
tesla764
  • 3
  • 2
3 Solutions
 
becraigCommented:
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
 
tesla764Author Commented:
I am importing from a .txt file.
I will try your suggestions in a minute.
Thanks.
0
 
edtechdbaCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
tesla764Author Commented:
The input data types are DT-STR.
0
 
tesla764Author Commented:
edtechdba I will try your suggestion in a few minutes. Thanks.
0
 
becraigCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now