Hi All, I have problem from last three days job is falling Below is the description for job failure. sql server 2005,sp2,standard edition Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:00:01 AM Error: 2012-08-02 07:05:49.26 Code: 0xC0047062 Source: Insurance_SR SalesForce USPMService_Request [1] Description: 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) End Error Error: 2012-08-02 07:05:49.27 Code: 0xC0047038 Source: Insurance_SR DTS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SalesForce USPMService_Request" (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. End Error Error: 2012-08-02 07:05:49.27 Code: 0xC0047021 Source: Insurance_SR DTS.Pipeline Description: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread1" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:00:01 AM Finished: 7:05:49 AM Elapsed: 347.781 seconds Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 7:00:01 AM Error: 2012-08-03 07:05:48.57 Code: 0xC0047062 Source: Insurance_SR SalesForce USPMService_Request [1] Description: 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) End Error Error: 2012-08-03 07:05:48.57 Code: 0xC0047038 Source: Insurance_SR DTS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SalesForce USPMService_Request" (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. End Error Error: 2012-08-03 07:05:48.57 Code: 0xC0047021 Source: Insurance_SR DTS.Pipeline Description: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread1" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:00:01 AM Finished: 7:05:48 AM Elapsed: 347.079 seconds Please its urgent.Maheshwar Reddy

It looks like Integration Services is unable to load a component. If this is a non-Microsoft component you need to make sure you have the 64-bit version installed if your running 64-bit SQL Server. If the package has worked in the past, you may need to reinstall it. Is this a Pragmatic Works Task Factory component? If so, and the above information doesn't help you, you may need to contact Pragmatic Works support for help. They are really good people and should be able to get you fixed up pretty quickly.

It looks like Integration Services is unable to load a component. If this is a non-Microsoft component you need to make sure you have the 64-bit version installed if your running 64-bit SQL Server. If the package has worked in the past, you may need to reinstall it. Is this a Pragmatic Works Task Factory component? If so, and the above information doesn't help you, you may need to contact Pragmatic Works support for help. They are really good people and should be able to get you fixed up pretty quickly.

There can be many reasons for this error. But most of it has to be due to the ODBC connection that you are using. Here is a link that might help you: http://www.sqlservercentral.com/Forums/Topic457099-148-1.aspx#bm577526 Hope this helps-Please mark the post as answered if it answers your question