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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS package errors

Author  Topic 

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2013-01-10 : 10:52:50
Hello All,

My SSIS package to import the Excel fiel to SQL was working fine until now.

I am getting this error. Please help.

The component could not be added to the Data Flow Task.

The object invoked has disconnected from its client. (Exception from HRESULT: 0x80010108 (RPC_E_DISCONNECTED)) (Microsoft.SqlServer.DTSPipelineWrap)

I will appreciate your help.

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2013-01-10 : 11:13:15
Does someone have the spreadsheet open?
Try it with an old spreadsheet to see if anything has changed.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

sqlpal2007
Posting Yak Master

200 Posts

Posted - 2013-01-10 : 11:54:35
I get this error even when I create a new SSIS package and drag the toolbox object. The spreadsheet is closed. None of the SSIS packages are working. they all are giving the same error. I think there is something wrong at the configuration level, install files or dlls.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-10 : 23:12:46
sounds like an installation issue to me

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -