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

x
?
Solved

SSIS

Posted on 2010-09-23
6
Medium Priority
?
1,106 Views
Last Modified: 2012-05-10

These are errors when I run my package, DataConversion in SSIS 2005. Need help. My server is w2003.


[Excel Destination 1 [3415]] Warning: Truncation may occur due to inserting data from data flow column "Copy of mycolumn1" with a length of 2000 to database column "mycolumn1"

with a length of 255.

[Excel Destination 1 [3415]] Warning: Truncation may occur due to inserting data from data flow column "Copy of mycolumn2 " with a length of 512 to database column "mycolumn2"

with a length of 255.


[Excel Destination 1 [3415]] Warning: Truncation may occur due to inserting data from data flow column "Copy of mycolumn3" " with a length of 512 to database column "mycolumn3"

with a length of 255.
0
Comment
Question by:VBdotnet2005
[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
  • 4
  • 2
6 Comments
 
LVL 15

Expert Comment

by:MohammedU
ID: 33749792
Make sure destination table columns table size is greater than or equal to the source data column sizes...

You need to check the length of the attribute should be same at the database as you are setting in the transformation.


0
 

Author Comment

by:VBdotnet2005
ID: 33749863

In data conversion Transformation Editor
Lenght I set it the same as the lenght on my DB. It is still errors. Any suggestions?
0
 
LVL 15

Expert Comment

by:MohammedU
ID: 33749902
0
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:VBdotnet2005
ID: 33756284
ValidateExternalMetadata property for the OLE DB Destination is set to False or True,
I still get the same errors above
0
 

Accepted Solution

by:
VBdotnet2005 earned 0 total points
ID: 33756916
0
 

Author Closing Comment

by:VBdotnet2005
ID: 34031783
THE LINK PROVIDED WORKS
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

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