converting dts pacjkages to SSIS packages

Question

converting dts pacjkages to SSIS packages

padmajapotharaju

Newbie

Points: 3
More actions
September 7, 2010 at 2:00 pm

#146833

hi, can any one please help me with the following error I encountered during converting DTS into SSIS
when Iam executing my DTS data pump task where Iam inserting data from a text file into a table.
the following is the error..
[94]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'Ecnounter_Duplicate_ID', table 'DDDADHOC_DB.dbo.stblENCOUNTER_DUPLICATES_CRN_FILE_Shadow'; column does not allow nulls. INSERT fails.".

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

padmajapotharaju (9/7/2010)
hi, can any one please help me with the following error I encountered during converting DTS into SSIS
when Iam executing my DTS data pump task where Iam inserting data from a text file into a table.
the following is the error..
[94]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'Ecnounter_Duplicate_ID', table 'DDDADHOC_DB.dbo.stblENCOUNTER_DUPLICATES_CRN_FILE_Shadow'; column does not allow nulls. INSERT fails.".

Please learn how to read!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Russel Loski SSCertifiable Points: 7059 More actions · Answer 2

"Cannot insert the value NULL into column 'Ecnounter_Duplicate_ID'" The problem is that your dataflow is not providing a value for the column 'Ecnounter_Duplicate_ID' and a value is required. Either you need to get the value from the text file or you will need a derived column to add a value.

Russel Loski, MCSE Business Intelligence, Data Platform