Can anyone sugest me steps to create the MSI Installer for SSIS packages
That is a bit of an open question.
I would use WIX to create the MSI. All you need to do is copy the SSIS package file to a folder location.
How you specify the location is up to you, and really depends on yoru requirements.
You could also create a Setup project in VS 2005, if you have it, or use one of the many other third party MSI creation tools.
If you wanted to install the packages in a manged location that would be harder. For the "SSIS Package Store" folder, then just copy the files to the folder. It may get a bit mnessy, but some points to help find that location. Try the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\Setup\DTSPath key to get the root folder. By default the sub-folder you want is Packages, but to be sure you would have to read the SSIS Service config file. To find this look in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile
You may have to write a custom action to handle the manged stores, so for that reason I'd say go with files!
No comments:
Post a Comment