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 |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-29 : 08:59:38
|
| I have created some packages which are using the same sharepoint file. So, when I try to run the jobs (having those packages independently) in parallel, I am not able to execute those. It shows an error stating that failed to acquire connection manager.What I feel is that as the packages are sharing the same file, those are not able to share the files properly and so the packages are not able to connect to the file.I just want to know if anyone of you know any changes that I need to make in the sharepoint file properties, in the package properties or in the job properties.Thank you. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-29 : 09:51:24
|
| If your talking about Checkpoints (file) then you should not share the file, especially parallel execution. The file will contain information about the package execution and its job is to track point of failure. The file will be deleted once complete and no failure, otherwise it will be used upon package rerun.Each package should have its own checkpoint file unless no other package(s) is running at any point during execution. |
 |
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-29 : 14:31:03
|
| No. I am not talking at all about the checkpoints. The source files that I have are sharepoint files, which are very similar to excel files, and the destination that I am using is the SQL Server Destination. So, I have packages that read the data from same excel file.Like, I have one file ABC which is a source in three packages.So, when I run these three packages simultaneously, these packages are not able to read the data from the same file ABC.Hope you are getting my point. If not, then I can try to explain further.Thank you. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-29 : 15:01:05
|
| Oh, okay I got it now but no answer to your question yet. |
|
|
|
|
|
|
|
|
Multiple packages using the same sharepoint file