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 |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2008-05-07 : 13:14:33
|
| Hi, I have some SSIS Deployment Manifest Files that needs to be copied over into another server. I am just using the Package installation wizard to do this. But it is taking to long to run.( I have 19 simple packages and it is taking 15 minutes). Is there any way that I can use to achieve better performance in this? |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-05-07 : 15:16:49
|
| Does this have anything to do with the number of tables and size of table?How long does it normally take for about 20 packages? |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-05-07 : 16:41:03
|
| You can copy and paste your compiled packages (bin directory) and paste them into the other server. If you use File System Storage you can drop the packages here "C:\Microsoft SQL Server\90\DTS\Packages\", which is the Stored Packages > File System storage. Not to certain what you mean my table size since they are just files. It should not take too long unless your network is real slow. |
|
|
|
|
|
|
Deployment Manifest copy is long!!!