http://sqlblogcasts.com/blogs/madhivanan/archive/tags/T-sql/data+truncation/sql+server/default.aspxTags: T-sql, data truncation, sql serverenCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/blogs/madhivanan/archive/2009/10/19/finding-out-problamatic-data-in-bulk-insert-data-truncation-error.aspxMon, 19 Oct 2009 10:07:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:12432Madhivanan0http://sqlblogcasts.com/blogs/madhivanan/rsscomments.aspx?PostID=12432http://sqlblogcasts.com/blogs/madhivanan/commentapi.aspx?PostID=12432http://sqlblogcasts.com/blogs/madhivanan/archive/2009/10/19/finding-out-problamatic-data-in-bulk-insert-data-truncation-error.aspx#commentsSuppose you want to import data from a text file to a table, one of the options is to use Bulk Insert command It allows to import data to the table, though one/more columns don&#39;t have enough size to get the maximum length of data from text file.It...(<a href="http://sqlblogcasts.com/blogs/madhivanan/archive/2009/10/19/finding-out-problamatic-data-in-bulk-insert-data-truncation-error.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=12432" width="1" height="1">sql serverT-sqlbulk insertdata truncation