Solution:
- Look at the name of the column for this error/warning.
- Go to SSMS and find the table
- Allow Null for that Column
- Save the table
- Rerun the SSIS
[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.".
What a great web blog . I like this blog because of its design and interface. event management Wellington, FL It is user friendly and it is nice to visit the blog.
ReplyDelete