I created a Fact Table with 3 Keys from dimension tables, like Customer Key, property key and territory key. Since I can ONLY have one Identity key on a table, what do I need to do to avoid populating NULLs on these columns..
That's right,however I still get the error below if I change to Not to Allow Nulls.Is there something I am missing.
[OLE DB Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Errorcode: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'Borrower_Key', table 'OLAP.dbo.Fact_Financials'; column does not allow nulls. INSERT fails.".
Yes. Your insert statement is trying to insert a NULL value, and SQL SERVER told you that is not allowed. Your front end (or middle tier) needs to screen the data before you try to ram it into the database.