I'm creating an SSIS package in the BID and I keep getting this error:
[gray][tt][Destination 9 - STILabels [1060]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'ReportIDMultiple', table 'STI.dbo.STILabels'; column does not allow nulls. INSERT fails.". [/tt][/gray]
The problem is that the destination table has a field in it that the source table doesn't and this fields doesn't allow nulls. When I try to execute the SSIS package it gives me the above error because its trying to insert a null into the field. I'm not sure why its doing this or how to fix it.
[gray][tt][Destination 9 - STILabels [1060]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'ReportIDMultiple', table 'STI.dbo.STILabels'; column does not allow nulls. INSERT fails.". [/tt][/gray]
The problem is that the destination table has a field in it that the source table doesn't and this fields doesn't allow nulls. When I try to execute the SSIS package it gives me the above error because its trying to insert a null into the field. I'm not sure why its doing this or how to fix it.