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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2010-04-21 : 07:40:10
|
| Hi i create an SSIS package and create the deployment folder. When i go to double click on the ssispackage.SSISDeploymentManifest file it won;t launch the wizard. Is there some setting i need to get this to work ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-22 : 00:02:22
|
| whats the error got?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2010-04-23 : 05:05:28
|
| No error as such i get a dialog box asking me to open the file in a choice of programs. Which is a standard MS option. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-23 : 05:16:43
|
In 2005 the manifest is linked to launch"SQL Server 2005 Integration Services Package Installation Utility"Maybe that's similar in 2008 and you can choose it from the list of applications?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2010-04-23 : 07:34:35
|
| I tried this option but it seem to be for executing the package rather than to install the package to a MSDB or to the file system. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-23 : 07:50:18
|
Was Installation Utility a part of the name?Then why should it be for executing?Hm...edit: typo
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2010-04-23 : 08:00:32
|
| No sorry the name of the program is SQL 2008 IS Package Execution, I see if i can go to the ..\100\DTS\Binn folder to see if i can get the dtsinstall.exe file this may launch it for me. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-23 : 08:30:53
|
Yes that is the right way.You have to link the manifest file type with dtsinstall.exe and it should work.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2010-04-27 : 10:21:22
|
| Just to complete the forum, I got this to work by just running dtsiinstall.exe "E:\solutionpath\bin\Deployment\SSISDeploymentManifest" and it launches the install wizard for me. |
|
|
|
|
|
|
SSIS Deployment Problem