troubleshooting Question

SSIS OLE DB Error

Avatar of danny1620
danny1620Flag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
27 Comments1 Solution12398 ViewsLast Modified:
Hi
I am trying to extract some data fom oracle server to the MS SQL server and in between i am converting few fileds to str,Text using Data conversion accordingly but It throws me Errors :

Error: 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 'ReportPeriod', table '  '; column does not allow nulls. INSERT fails.".
Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Destination Input" (41)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (41)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component " " (28) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (41). 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.  There may be error messages posted before this with more information about the failure.

These are the errors which i get for most of the packages and few other packages which are very much similar are working fine... Can any One tell me a solution to this...

Thanks

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 27 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 27 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros