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)
 document is open by another project

Author  Topic 

Tasta
Yak Posting Veteran

60 Posts

Posted - 2009-01-01 : 05:22:09
Does anybody what to do in case of "This document is open by another project" error?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-01 : 13:29:19
which document are you trying to open? are you using another parallel task which access the document or is it inside loop container?
Go to Top of Page

Tasta
Yak Posting Veteran

60 Posts

Posted - 2009-01-04 : 04:18:36
Hi ! Thanks for replying. A point is I'm opening nothing. I'm trying to work with my SSIS project, for example a message appears while trying to build SSIS.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-04 : 04:24:14
quote:
Originally posted by Tasta

Hi ! Thanks for replying. A point is I'm opening nothing. I'm trying to work with my SSIS project, for example a message appears while trying to build SSIS.


inside SSIS are you trying to open any document using script task or something?
Go to Top of Page

Tasta
Yak Posting Veteran

60 Posts

Posted - 2009-01-04 : 04:38:26
I'm copying Data to some Excel files using script task,if that's what you are asking, besides - no.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-01-04 : 04:46:02
The destination Excel file cannot be open in any other way during export!



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Tasta
Yak Posting Veteran

60 Posts

Posted - 2009-01-04 : 04:52:53
I'm talking about designing stage, not running. And a message don't relate to excel - it's related to the file of the package - FACTS.dtsx in my case, and it's not opened in another project, but I'm ready to close it - BUT HOW!!!
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2009-01-05 : 06:54:24
File > Close is how you close the package FACTS.dtsx. If that is not what you are looking for, then who knows how to or what your are saying.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-05 : 09:05:27
quote:
Originally posted by Tasta

I'm talking about designing stage, not running. And a message don't relate to excel - it's related to the file of the package - FACTS.dtsx in my case, and it's not opened in another project, but I'm ready to close it - BUT HOW!!!


oh...try spotting out other projects where you've included the same package.
Go to Top of Page

Tasta
Yak Posting Veteran

60 Posts

Posted - 2009-01-05 : 09:52:51
quote:
Originally posted by visakh16

quote:
Originally posted by Tasta

I'm talking about designing stage, not running. And a message don't relate to excel - it's related to the file of the package - FACTS.dtsx in my case, and it's not opened in another project, but I'm ready to close it - BUT HOW!!!


oh...try spotting out other projects where you've included the same package.


That's exactly my problem ! How can it be done - remove it from all backup projects? And still it's possible I'll not find it because it's open in none ? I'm afraid it happened when electricity was shut down and Visual Studio simply cannot mark a package as closed.
Go to Top of Page
   

- Advertisement -