Scenario - During SSIS development work I found a warning message over a data flow task.
(Find the below screen shot for your reference)
Root cause - This warning message appears over the SSIS data flow task when the datatype length of the source column is more than the datatype length of the destination column.
Resolution - In order to remove this warning message from SSIS solution, make sure datatype length of the source column should be equal to the datatype length of the destination column.
There can be two possible approaches to resolve this warning message -
1. Using Advance editor
Step 1 - Right click to the data source(Oledb Source) and select "Show Advanced Editor", then go to Input and Output Properties tab.
Step 2 - Select Oledb Source Output then expand output columns.
Step 3 - Choose appropriate column and you can change the column data type as well as length of it.
(Find the below screen shot for your reference)
2. Using Data Conversion
Take a data conversion task to manipulate the data type length of that particular column.
As soon as source and destination data type length will be equal, warning message will be disappeared
I hope this article will help to prepare a clean SSIS solution without any warning message.
(Find the below screen shot for your reference)
Root cause - This warning message appears over the SSIS data flow task when the datatype length of the source column is more than the datatype length of the destination column.
Resolution - In order to remove this warning message from SSIS solution, make sure datatype length of the source column should be equal to the datatype length of the destination column.
There can be two possible approaches to resolve this warning message -
1. Using Advance editor
Step 1 - Right click to the data source(Oledb Source) and select "Show Advanced Editor", then go to Input and Output Properties tab.
Step 2 - Select Oledb Source Output then expand output columns.
Step 3 - Choose appropriate column and you can change the column data type as well as length of it.
(Find the below screen shot for your reference)
2. Using Data Conversion
Take a data conversion task to manipulate the data type length of that particular column.
As soon as source and destination data type length will be equal, warning message will be disappeared
I hope this article will help to prepare a clean SSIS solution without any warning message.
12 Comments
Option #1 worked perfectly for me! And screenshots were a bonus! Thanks!
ReplyDeleteGood one
ReplyDeleteOption #1 very good ! Thanks!
ReplyDeleteNice
ReplyDeleteThanks it helped a lot :)
ReplyDeleteThank you!
ReplyDeletevery good!!!!!!
ReplyDeleteveryvery good!!!
ReplyDeleteThanks :)
ReplyDeletethis worked thanks!
ReplyDeleteStill useful!
ReplyDeleteWorked for me.. thabk you so much for the screenshot.
ReplyDelete