Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Brittney10
Posting Yak Master
154 Posts |
 Posted - 2012-10-17 : 10:52:34
|
| I have about 30 columns that I need to check the length on to ensure they are is less than or equal to 50. I know how I can achieve this, but is there a quick and easy was to do this without having to create derived columns or conditions on each and every column? Each record should log with an error message if truncation may occur (but i don't want to get to the actual insertion of the data at the table-level for this to fail and log). |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-17 : 23:31:06
|
| SSIS gives you warning by default if length of column falls below target table column length------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Length Validation Before Truncat Error