May 7, 2008 at 10:38 am
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?
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 7, 2008 at 1:17 pm
You get me thinking as well, I too have a number of packages to be deployed to another server.
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?
[font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]
May 8, 2008 at 11:34 am
It sounds like you are executing the wizard on one server (or your PC) and deploying the packages to a remote server. I would copy the entire Deployment folder that gets created when you build your SSIS project to the remote server and execute the wizard from there. It will probably run much faster that way.
Hope this helps,
Bryan
May 8, 2008 at 11:44 am
Well, let me summarize your advise:
You are telling me that it MAY work faster if I copy the whole folder from my PC(DEVELOPMENT) to the remote server(QA) through "Copy and Paste" in a Network Drive and the Run the Package Installation Wizard in the remote server itself?
Am I right? Did i put it the correct way?
If so, have you or anyone else who is reading this post tried this before? Has anyone come up with any kind of problem?
Or can someone elaborate how you are deploying your package?
Please advise!
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 8, 2008 at 12:17 pm
Your summarization is correct. Copying the Deployment folder to the server on which you want to install the packages and running the deployment wizard there is the recommended process. I said that it would 'probably' be faster because a lot depends on your hardware (disk, network) configuration. But in general, this is definitely a faster way to deploy your packages and the way that I always deploy mine (many clients, many servers, many packages).
If you have any other questions, let me know.
Thanks,
Bryan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply