July 2, 2009 at 9:05 am
All,
First post here, although I've been a subscriber for years.
I recently developed an SSIS package that uses a Script Task to open Excel spreadsheets and refresh the different pivot tables once our daily data refresh migration has completed.
It works great on my machine when I developed the package but bombs out the moment we run the package in a SQL Server job on the database server.
Here is the exact error:
-------------------
Error: 2009-07-01 11:23:07.87
Code: 0xC0047062
Source: Data Flow Task Refresh Pivots [68]
Description: System.Exception: Cannot create ActiveX component.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper90 wrapper, Int32 inputID, IDTSBuffer90 pDTSBuffer, IntPtr bufferWirePacket)
End Error
Error: 2009-07-01 11:23:07.87
Code: 0xC0047022
Source: Data Flow Task DTS.Pipeline
Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Refresh Pivots" (68) failed with error code 0x80131500. The identi... The package execution fa... The step failed.
----------
I've been reading up on this error quite a bit and I think I know what the problem is. The database server does not have Excel installed so I think this is the problem since the package is physically opening spreadsheets and modifying them.
Does this sound logical to you? Hoping that someone will know for certain, one way or the other.
Thanks.
July 2, 2009 at 9:59 pm
You know, the first thing that I thought when I started reading this post was that it is probably because you do not have the relevant bits of Excel installed on the server. Try that and see whether your problem goes away.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply