January 23, 2006 at 9:02 am
I was curious how other folks are using SSIS in production. In the past we have had numerous DTS packages on most of our servers. This has been both good and bad as we have all the packages separate, but there is no central place for managing them.
With 2005 we are considering moving towards having all our packages located on 1 server. Our thinking here is that there is 1 place to manage the packages, we can possibly consolidate multiple DTS pkgs that do the same thing into 1 SSIS package that pushes to multiple environments, and we will not have to install the Integration Services Service on each server we want to run SSIS packages against.
Is this a strategy others are using or are we possibly overlooking some things?
Any input appreciated,
-Erich
January 24, 2006 at 2:33 am
I prefer to not have my packages on any server - I have them as flatfiles instead.
You can still control them from the SSIS node in SSMS.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
January 24, 2006 at 7:39 am
Do you have the flat files on a central server? How do you run your packages?
Thanks for the reply,
Erich
January 24, 2006 at 7:44 am
Yes, all stored on a central server.
We run them using dtexec.exe.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
January 24, 2006 at 7:48 am
Thanks for all your help! Also, your blog has been a big help in coming up with strategies for our implementation of Integration Services.
Thanks, Erich
January 24, 2006 at 8:20 am
No problem. You should take a look at the post concerning folder structure cos that has alot to do with the deployment issues that you are currently weighing up.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply