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 |
|
richardps
Starting Member
33 Posts |
 Posted - 2007-11-15 : 06:33:23
|
| Hi,I need to establish a good method of deploying SSIS packages to my LIVE server from my DEV server. Some questions:1) What does the Package Installation Wizard (file system deployment method) do for me that copying the .dtsx files manually doesn't?2) Does SQL Server Deployment method in the PIW add them to MSDB instead of the file system?3) I need to source-control the SSIS packages too but am not using Sourcesafe so can't use the built-in BIDS features for that. Instead I anticpate that I'll be manually source-controlling the .dtsx xml files and probably manually copying them to the file-system on the live server.4) Does this scenary work? - ideas / improvements welcome:Use the Package Installation Wizard (file-system) for the initial deployment and any subsequent changes, just re-copy the files manually to the live file-system - would this work??Many thanks in advance for all responses! |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-15 : 09:19:57
|
| This is a great question, because I, for one had been fighting through the same issue.To your 1). PIW will check other conditions, including let you change configurations.2) you have an option to install either the file system or the msdb.I will leave 3) and 4) to more experienced guys. |
 |
|
|
richardps
Starting Member
33 Posts |
Posted - 2007-11-20 : 06:05:58
|
| BUMP |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-20 : 08:26:49
|
| I just save the packages as files and to deploy copy them to a folder on the server.They are just xml files so the source control application doesn't matter.The important thing is the config file/table access - how it is defined (location/name) and what it holds.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
richardps
Starting Member
33 Posts |
Posted - 2007-11-20 : 12:17:09
|
| Thanks!I have tried SQL Server Deployment and that works great and entries appear in MSDB as expected.However, if I choose File System deployment from the wizard, all that it seems to do is just copy the files to the File System I specify. It doesn't add them to STORED PACKAGES|File System in the Integration Services server details in the Object Browser.Is this normal? |
|
|
|
|
|
|
I have my SSIS Package in DEV - now what?