tag:blogger.com,1999:blog-69326392081620917942024-09-07T14:39:46.077-07:00[OLE DB Destination [26]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error". [OLE DB Destination [26]] Error: There was an error with input column "Server" (48) on input "OLE DB Destination Input" (39). The column status returned was: "The value violated the integrity constraints for the column.".Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6932639208162091794.post-85877263121947037292010-04-29T10:01:00.000-07:002010-04-29T10:01:04.797-07:00<span style="color: red;">SQL Issue</span>: The value violated the integrity constraints for the column<br /> <br /> Solution:<br /> <ol><li>Look at the name of the column for this error/warning.</li> <li>Go to SSMS and find the table</li> <li>Allow Null for that Column&nbsp;</li> <li>Save the table</li> <li>Rerun the SSIS</li> </ol>Anonymoushttp://www.blogger.com/profile/06731273299234474960noreply@blogger.com1