Script for deploying SSIS - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Script for deploying SSIS

Author

Topic

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-10-05 : 16:54:52

Greetings

I am trying to deploy all my SSIS packages using powershell or some other scripting language. I want this script to also manipulate the Config file in order to have it and change values in it.

Any leads?

Thanks

If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-06 : 01:22:40

any special reason you want to do this using powershell scripts?
Doing deployment using deployment utility is much simpler. it even gives you ability to change values of config

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2011-10-06 : 11:12:34

I agree 100%. dba is the special reason. dba is not ready for config files. I spent over 4 hours with dba on how to deploy with config and manifest and all those beautiful things. After we were done dba still had no clue what just happened. Hence the PowerShell one click script.

Anyways I figured out how to do it via PowerShell, change values in config file for sqa/stg/prd.

Thanks sir

If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-06 : 12:22:18

np
just checked

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources