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.
| 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. |
 |
|
|
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. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS package errors