July 7, 2009 at 11:11 pm
In Control Flow tab, i have taken one excel source and mapping with excel connection manager its fine and then i want to push the data from excel to DB table so i have taken OLEDB Destination and mapped with the respective connection manager whic is having required DB table.
And then both are linked.
In this case i'm getting below error.
Transaction may occur due to inserting data from data flow column "ProductName" with length of 255..this error occur in SSIS package
Please guide me.
Thanks in advance.
July 8, 2009 at 8:36 am
I think the error is actually "Truncation may occur...". By default in the Excel data source the length of character columns is set to 255 and this error is telling you that you have mapped a column with a length of 255 to a database column with a length less than 255, thus any character beyond the defined length of the database column will be truncated. You can go into the Advanced properties of your Excel source and change the length of the offending column, you can put in a derived column transform and create a smaller column, you can change the column length in the database, or you can ignore the error as it is a warning not an error that will cause the package to fail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply