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 2005 Forums
 SSIS and Import/Export (2005)
 Error!!!!!!!

Author  Topic 

on7june
Starting Member

41 Posts

Posted - 2008-05-15 : 06:50:58
Hi when i try to execute a package it shows the following error, What causes this error and how should i rectify this.

"object invoked has disconnected from its clients"
"Do you want to terminate this instead"

Sarvan

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-05-15 : 07:09:15
What are the components connecting to where? That's too broad to solve from here.
Go to Top of Page

on7june
Starting Member

41 Posts

Posted - 2008-05-15 : 08:01:36
I have a sequential container within that sequential container i have another sequential container which has 3 components in it. Data flow task1 (To validate the text file) which is connected with Execute sql task (Truncates the table) and finally Another data flow task2 which holds the full flow of data.
To detail the data flow task2 please find the attached picture.

Like this i have 25 sequential Containers in my package. I got this error only now, earlier i have executed this same package successfully.
Go to Top of Page

karthik_padbanaban
Constraint Violating Yak Guru

263 Posts

Posted - 2008-05-15 : 08:44:22
quote:
Originally posted by on7june

Hi when i try to execute a package it shows the following error, What causes this error and how should i rectify this.

"object invoked has disconnected from its clients"
"Do you want to terminate this instead"

Sarvan


are you connecting any remote servers??
Go to Top of Page

karthik_padbanaban
Constraint Violating Yak Guru

263 Posts

Posted - 2008-05-15 : 08:44:53
are you connecting any remote servers??
if so check for the authentication credentials.,

Go to Top of Page

on7june
Starting Member

41 Posts

Posted - 2008-05-15 : 08:53:44
Yes i am connecting to a remote server. I have checked and everything is fine (Other packages are running fine which has this same destination)

Sarvan
Go to Top of Page

on7june
Starting Member

41 Posts

Posted - 2008-05-15 : 08:57:20
Thanks a lot friends who have responded to my query. Now the package is executing fine. I just closed all the packages from visual studio and then tried opening from solution explorer now it is working fine.

Sarvan
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-05-15 : 09:00:12
We have been getting lost connections lately. Not sure what the deal is but it's annoying because the same package runs fine until then. Glad you're okay now.
Go to Top of Page

on7june
Starting Member

41 Posts

Posted - 2008-05-15 : 10:01:17
Ooops, I got the same error again. The package was executed perfectly when i try to click the "Stop Debugging" icon it shows the same error.

Sarvan
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-05-15 : 17:12:33
Just for the heck of it, check and make sure "Work Offline" is not selected.
Go to Top of Page
   

- Advertisement -