| Author |
Topic |
|
Tasta
Yak Posting Veteran
60 Posts |
 Posted - 2008-12-31 : 09:25:31
|
| Hello !Does anybody know how to solve a problem when you stop receiving an option of "execute container" in a package. Any help is welcome |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 09:47:07
|
| execute container? what do you mean by that? do you mean sequence container or loop? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-01 : 03:39:24
|
| Hi! I don't receive any message, only cannot execute sequence container - simply don't have a line on right-clicking a mouse.The only message I receive is "This document is open by another project" - and nobody except me in this specific project had opened this package. Besides, I copied the problem package to the new one, it looked like the problem disappeared, and then in a couple of hours it's back ! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-01 : 13:30:13
|
| what are you doing inside container? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-01-02 : 06:17:37
|
| Maybe something is writing to the same flatfile during loop? |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-04 : 01:58:33
|
| The problem is with all containers in the package, while other packages remain executable. I think it's something with the message "the document is open in another project" that referres to this problematic package.Nobody except me works with SSIS packages, but it's possible that project was not closed properly, but now I don't know how to fix it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-04 : 03:48:20
|
quote:
Originally posted by Tasta
The problem is with all containers in the package, while other packages remain executable. I think it's something with the message "the document is open in another project" that referres to this problematic package.Nobody except me works with SSIS packages, but it's possible that project was not closed properly, but now I don't know how to fix it.
you still didnt answer me regarding tasks inside container |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-04 : 04:34:40
|
| There're a lot of tasks (30-40) organized in 6 sequence containers plus some Sql Tasks. In containers Data flow tasks, Sql tasks, script tasks . It's BI project and a proble is with one package of 8, dealing with loading a set of tables from one DB to another with data manipulations. I don't know what specifically is the reason for the problem' so I don't know where exactly to look. I tried to copy a content of this package to a new one, at first it worked, and in a couple of hours the problem returned. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-01-05 : 07:10:52
|
| Execute each Sequence Container at a time but in order (right-click, Execute Container) to narrow down the problem. After each run click "Progress" tab and look for exclamation point inside a circle which gives you a hint if there's a problem.It helps also if you know the logic within them. Have you looked into what each container is doing? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-05 : 09:04:14
|
quote:
Originally posted by Tasta
There're a lot of tasks (30-40) organized in 6 sequence containers plus some Sql Tasks. In containers Data flow tasks, Sql tasks, script tasks . It's BI project and a proble is with one package of 8, dealing with loading a set of tables from one DB to another with data manipulations. I don't know what specifically is the reason for the problem' so I don't know where exactly to look. I tried to copy a content of this package to a new one, at first it worked, and in a couple of hours the problem returned.
where is file accessed at? inside which script task? |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-05 : 09:45:35
|
quote:
Originally posted by rgombina
Execute each Sequence Container at a time but in order (right-click, Execute Container) to narrow down the problem. After each run click "Progress" tab and look for exclamation point inside a circle which gives you a hint if there's a problem.It helps also if you know the logic within them. Have you looked into what each container is doing?
But thats exactly the problem - I have no "Execute Container" line on right click - for every task and container in this package. Does anybody have an idea what can lead to this? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-01-05 : 09:55:04
|
| Are you opening the package(s) by right-click, Edit file (FACTS.dtsx) from a directory folder or opening from BI studio? If so, Execute Container is not there.Import Existing Package is what you need to do and add the package to the SSIS Packages folder. open the package and right-click again. It should be there now. |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-06 : 02:50:26
|
| Hi, rgombina ! Thanks you for help,but it still doesn't work. I tried also to export the package from database and the problem remains. By the way, hwole package is running quite well, the problem is I cannot run with debugging on specific container and have to run it on the server as a whole package . |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-01-06 : 03:17:10
|
| Try this - create brand new package and drag a Sequence Container, right-click to see if Execute Container is present. |
|
|
|
Tasta
Yak Posting Veteran
60 Posts |
Posted - 2009-01-06 : 09:03:29
|
| I know this trick,I used it at least thrice,but it's a lot of work to recreate connection managers, reconnect, rearrange and so on. But the problem returns again and I'd really like to solve it. If you have other ideas, I'd like to try. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-06 : 09:44:56
|
quote:
Originally posted by Tasta
Hi, rgombina ! Thanks you for help,but it still doesn't work. I tried also to export the package from database and the problem remains. By the way, hwole package is running quite well, the problem is I cannot run with debugging on specific container and have to run it on the server as a whole package .
check package properties and see if read only property is checked |
|
|
|
|
Option of "execute container" missing