Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ckkim7283
Starting Member
1 Post |
 Posted - 2008-03-16 : 15:04:46
|
| I am new to SQL Server and am trying to import rows from Excel using SSIS and am getting the following error.Does anyone have any ideas on how to resolve??SSIS package "Package.dtsx" starting.Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.Warning: 0x80047076 at Data Flow Task, DTS.Pipeline: The output column "SupplierID" (161) on output "Excel Source Output" (9) and component "Excel Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.Warning: 0x80047076 at Data Flow Task, DTS.Pipeline: The output column "SupplierID" (161) on output "Excel Source Output" (9) and component "Excel Source" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.Information: 0x402090DF at Data Flow Task, OLE DB Destination [583]: The final commit for the data insertion has started.Error: 0xC0202009 at Data Flow Task, OLE DB Destination [583]: 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 'SupplierID', table 'Northwind.dbo.Suppliers'; column does not allow nulls. INSERT fails.".Information: 0x402090E0 at Data Flow Task, OLE DB Destination [583]: The final commit for the data insertion has ended.Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (583) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (583)" wrote 1 rows.Task failed: Data Flow TaskWarning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.SSIS package "Package.dtsx" finished: Failure. |
|
|
tprupsis
Yak Posting Veteran
88 Posts |
Posted - 2008-03-16 : 23:44:25
|
| Here's the key statement:An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'SupplierID', table 'Northwind.dbo.Suppliers'; column does not allow nulls. INSERT fails.".You seem to have a null value in the field you have mapped to the SupplierID column. |
 |
|
|
|
|
|
|
|
Import From Excel Using SSIS