May 8, 2015 at 6:34 am
Hi Guys,
I need your help how to solve the below error.
Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database column "FilePath" with a length of 90 to data flow column "FilePath" with a length of 67.
Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database column "FileName" with a length of 33 to data flow column "FileName" with a length of 10.
I just find out the error because of Filename length. If filename more than 6 characters, the error will occurs
But if my filename <=6 characters, the package is successfully executed.you
Please help me. thank you
May 8, 2015 at 6:46 am
am_mal80 (5/8/2015)
Hi Guys,I need your help how to solve the below error.
Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database column "FilePath" with a length of 90 to data flow column "FilePath" with a length of 67.
Warning: 0x802092A8 at Data Flow Task, OLE DB Source [1]: Truncation may occur due to retrieving data from database column "FileName" with a length of 33 to data flow column "FileName" with a length of 10.
I just find out the error because of Filename length. If filename more than 6 characters, the error will occurs
But if my filename <=6 characters, the package is successfully executed.you
Please help me. thank you
Go into the Advanced Editor for your Data Source and increase column widths as indicated by the warnings. Note: they are not errors.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 8, 2015 at 9:09 am
Hello Phil,
Great!!! after follow your instruction, my problem solved....:-):-)
thanks a lot for your help.
May 8, 2015 at 9:14 am
No problem. Thanks for posting back.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply