how to solve :Error: 0xC0047062 at CTPKPF, DataReader Source [1]: System.NullReferenceException: Object reference not set to an
hi i need help to solve following error in ssis package when i aun :: Error: 0xC0047062 at CTPKPF, DataReader Source [1]: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) Error: 0xC0047038 at CTPKPF, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Source" (1) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at CTPKPF, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at CTPKPF, DTS.Pipeline: Post Execute phase is beginning. Information: 0x40043009 at CTPKPF, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at CTPKPF, DTS.Pipeline: "component "OLE DB Destination" (1993)" wrote 0 rows. Task failed: CTPKPF
April 7th, 2007 6:05am

Could you givea little background on your problem? What type of data source is it, is this a component you are creating programatically or directly in the IDE?
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2007 11:17am

Hi Im geeting the same error. Ive got a DBF FileODBC connection importing +-300,000 lines of data a day. The data flow uses a DataReader. Interestingly, I run the SSIS in debug mode andit imports all the data butas it completes, theDataReader box flashes greenand then fails. Could this be something to do with the connection trying to exit? Errors are as follows: [DataReader Source 1 [10666]] Error: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) [DTS.Pipeline] Error: The PrimeOutput method on component "DataReader Source 1" (10666) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. [DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038. Thanking you in advance D
April 11th, 2007 5:39am

Hi Everyone, I'm running into the same problem. Here is my scenario. ADO .NET Provider for Teradataused in adata reader- Query - select * from table where month = mm/dd/yyyy and category = 'my category' to an Oracle destination so - in short - the whole package is simplified to 2 objects Data Reader Source ---> Oracle Bulk Loader Destination (Persistent Connector) The package fails at the end (approx 1000 rows remain) dies leaving out the last 1000 rows... There must be something I'm overlooking in the configuration - please, can anyone help with this? Error: 0xC0047062 at Data Flow Task, DataReader Source 1 [224]: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr ppBufferWirePacket) Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: The PrimeOutput method on component "DataReader Source 1" (224) returned error code 0x80004003. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038. Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039. 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 "Oracle Bulk Load Destination" (1599)" wrote 445916 rows. Task failed: Data Flow Task Warning: 0x80019002 at SLSVIEWS_to_Oracle: The Execution method succeeded, but the number of errors raised (5) 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 "SLSVIEWS_to_Oracle.dtsx" finished: Failure. Steve
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2007 7:08pm

Hi guys, The NullReferenceException could occur when the external data source has changed its columns, in particular added new columns. One solution is to go to the package, and refresh the DataReader Source component andadjust the column mappings accordingly. Please let me know if this works. Thanks, Jia
April 30th, 2007 2:40pm

Ah yes, that is it. I noticed there was a column on the input that was not mapped. The odd thing was - I could not select the column from the input even though the query explicitly listed it in the select.... so I re-created the package and all worked. One complaint - the error waiting till the end of the load to inform me of the problem. That is a big time sync when loading 2+ million records. so the solution is: When you see this error - check all column mappings - be sure they are all mapped, be sure your query explicitly chooses these columns and don't do a "select * from table where [condition] = [something] - that technique burried me and I was unable to determine the failing column. Thanks again! Steve
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2007 8:03pm

All happens if the recordset being returned has null values in the field. Make sure NONE of the rows returned have null/nothing values or else the unicode values don't generate objects hence the error. I proved this myself by take the table that had null values and making a view that stripped out the null values. Problem solved.
November 7th, 2007 5:59pm

I found this error also happens with an ODBC Teradata source going to an OLEDB SQL Server 2000 destination even when all the source columns are explicitly defined in the select statement but one of the columns does not exist in the physical destination table.
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2008 3:44pm

That work, in my project.
October 16th, 2009 5:51am

Iam also getting similar error in our project, Is there anything that anyone can help me with, this error iam getting basically when iam using the script component in ssis to read trace file from ssas. I checked the rows everything is fine.
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2012 8:34am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics