I am developing an SSIS package and trying to update an existing table with info from new columns. In other words, this table already has records for my input CSV file. But this CSV file has additional columns for these same records. So
I need to keep existing columns in table. How can I achieve this?
I began by using Import/Export Wizard and it did most of hard work for me. But one of the columns previously defined in this table doesn't allow NULLs. So although I want these new rows to map into existing table, it seems like this will just
overwrite the table values and I get the error below. How can I fix this?
I have a Flat File CSV source, Data Conversoin, and DestinationConnectionOLEDB
Error: 0xC0202009 at Data Flow Task 1, Destination - j5c_ALL_DATA2 : 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: "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 'timestamp', table 'berkeley.dbo.j5c_ALL_DATA2'; column does not allow nulls. INSERT fails.".
Error: 0xC0209029 at Data Flow Task 1, Destinati
View Complete Post