Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup
Hi David, yes, this is exactly the workflow I want to implement. And yes, you are right! If there is a way to pass in the connection parameters from the .NET application that is definitely the way to go! I didn't know that I can pass in all that information via parameters programmatically. So, I guess I don't need any outside configuration in the setup. After I call the SSIS fuzzy functionality from my C# application I want to persist the data back to a table and then have a nice GUI to display the results. It shoud be divided into a left and a right part with the customer data (mainly company names) on one side and the reference data on the other side. The user should be able to manually change the mapping between both sides, either by ticking a box or by dragging a line from the left side to the right side. I already searched quite hard to find a nice control with these possibilities including filtering etc. but could not find anything until now. So, if you also have any ideas for this that would be even better!!! If you have further questions regarding the process please contact me. Thanks a lot Daniel David Reed (SQL) wrote: Howdy, Daniel. Let's see if I understand you proposed workflow: 1. The installer contains the SSIS package and custom .NET executable. 2. The installer solicits connection information during setup that you want to write to an XML config file. 3. The .NET application will execute the package to do a fuzzy and then do what with the results? Questions: If you're already writing a custom WinForms or XAML app AND the SSIS package is invisible to the user, why not have the application itself provide the user the ability manage connection parameters? If you provide connection management features in your custom application, you can then persist them however you wish from .NET and pass them to the SSIS package as parameters programmatically or via command line to DTExec. In this scenario, I don't see a reason to use the registry, environment variables or XML configuration files. -Original Message- From: dschmitz [mailto:daniel.schm...@dealogic.com] Sent: Friday, January 30, 2009 07:07 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup Hi there! Thanks for your answer! We will either use XML config files or environment variables. This decision is still open. What I want to do is to execute the SSIS package from a C# application to perform a Fuzzy lookup to compare addresses. There are around 1 million data rows to compare. The result should be displayed on a Winforms GUI. So, we have to pass the connection parameters to the databases into the SSIS package. I thought of writing them from C# into the XML Config file, but maybe environment variables work out better. If you have any suggestions in how to achieve this, I would be very thankful (mainly in how to create the Wix setup...) Regards Daniel From: David Reed (SQL) (via Nabble) [mailto:ml-user+60230-489561...@n2.nabble.com] Sent: 29 January 2009 17:46 To: Daniel Schmitz Subject: Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup Been there, done that a few times. It depends on the package, Daniel. How are the package configurations setup? Environment variables? User registry keys? XML config files? I've used all three, including manipulating the XML files at installation time to persist user selections made during setup. Warning: oob functionality in SSIS doesn't support configuration in HKLM. Are you planning to execute the package immediately post-installation? I've had trouble with environment variables in that scenario, but user registry keys and XML files work fine. -Original Message- From: dschmitz [mailto:daniel.schm...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=0 ] Sent: Thursday, January 29, 2009 09:14 To: wix-us...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=1 Subject: [WiX-users] Wix - integrating Microsoft SSIS package into setup Hello, is there a way to integrate a Microsoft SQL Server SSIS package into a Wix setup? The setup should install the SSIS package and if possible allow to define some user settings. I'm not sure if I need a Wix custom action to achieve this (maybe somebody already wrote one), or if there is another way to do this. I would appreciate any help on this issue. Thanks Daniel -- View this message in context: http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup -tp2240080p2240080.html Sent from the wix-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword
Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup
Hi there! Thanks for your answer! We will either use XML config files or environment variables. This decision is still open. What I want to do is to execute the SSIS package from a C# application to perform a Fuzzy lookup to compare addresses. There are around 1 million data rows to compare. The result should be displayed on a Winforms GUI. So, we have to pass the connection parameters to the databases into the SSIS package. I thought of writing them from C# into the XML Config file, but maybe environment variables work out better. If you have any suggestions in how to achieve this, I would be very thankful (mainly in how to create the Wix setup...) Regards Daniel From: David Reed (SQL) (via Nabble) [mailto:ml-user+60230-489561...@n2.nabble.com] Sent: 29 January 2009 17:46 To: Daniel Schmitz Subject: Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup Been there, done that a few times. It depends on the package, Daniel. How are the package configurations setup? Environment variables? User registry keys? XML config files? I've used all three, including manipulating the XML files at installation time to persist user selections made during setup. Warning: oob functionality in SSIS doesn't support configuration in HKLM. Are you planning to execute the package immediately post-installation? I've had trouble with environment variables in that scenario, but user registry keys and XML files work fine. -Original Message- From: dschmitz [mailto:daniel.schm...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=0 ] Sent: Thursday, January 29, 2009 09:14 To: wix-us...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=1 Subject: [WiX-users] Wix - integrating Microsoft SSIS package into setup Hello, is there a way to integrate a Microsoft SQL Server SSIS package into a Wix setup? The setup should install the SSIS package and if possible allow to define some user settings. I'm not sure if I need a Wix custom action to achieve this (maybe somebody already wrote one), or if there is another way to do this. I would appreciate any help on this issue. Thanks Daniel -- View this message in context: http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup -tp2240080p2240080.html Sent from the wix-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ WiX-users mailing list wix-us...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=2 https://lists.sourceforge.net/lists/listinfo/wix-users -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ WiX-users mailing list wix-us...@... http://n2.nabble.com/user/SendEmail.jtp?type=nodenode=2240268i=3 https://lists.sourceforge.net/lists/listinfo/wix-users This email is a reply to your post @ http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup -tp2240080p2240268.html You can reply by email or by visting the link above. Information contained in this e-mail is confidential and intended for the use of the addressee only and potentially legally privileged. The contents of this email are subject to Dealogics Email Usage Policy which is available at our website at www.dealogic.com/en/email.htm. We cannot accept liability for any damage which you sustain as a result of software viruses, hyperlinks or the like; please carry out your own virus checks in accordance with good computing practices before opening attachments. For corporate and company registration information, please refer to our website at www.dealogic.com. -- View this message in context: http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup-tp2240080p2245210.html Sent from the wix-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Wix - integrating Microsoft SSIS package into setup
Hello, is there a way to integrate a Microsoft SQL Server SSIS package into a Wix setup? The setup should install the SSIS package and if possible allow to define some user settings. I'm not sure if I need a Wix custom action to achieve this (maybe somebody already wrote one), or if there is another way to do this. I would appreciate any help on this issue. Thanks Daniel -- View this message in context: http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup-tp2240080p2240080.html Sent from the wix-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Search Replace template parameters in SQL
Hello, we have lots of SQL scripts here using SQL template parameters looking like this: SQL Management Studio has the possibility to fill these parameters with values using Ctrl+Shift+M Now we are going to automate the execution of these scripts with WiX. The standard Wix SQL cmds SqlScript / SQLString don't seem to do the trick here. I think the only way to solve this is to use a Custom Action which does Search Replace (maybe with regular expressions) and to pass in the parameter name and parameter value. Does anybody already have an existing solution / a custom action which can solve this problem and wouldn't mind sharing the solution? Thanks in advance Daniel -- View this message in context: http://n2.nabble.com/Search---Replace-template-parameters-in-SQL-tp1300477p1300477.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] MSIEXEC installlevel feature
Hello, I'm just wondering if it is possible with MSI and with Wix to have 2 features and to choose via msiexec command line which of the two features should be installed. If I give a feature a Level attribute in Wix msi installs everything with a feature LEVEL = the specified INSTALLLEVEL. But I want to choose exactly one feature, so just equal instead of =. So if I have: A: Configuration 1 LEVEL=1000 B: Configuration 2 LEVEL=2000 I can either install A or A+B but not just B. Does anybody know, if there is another possibility? Thanks Daniel -- View this message in context: http://n2.nabble.com/MSIEXEC-installlevel-feature-tp1082699p1082699.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] MSIEXEC installlevel feature
Great! That was exactly what I needed! Thanks a lot again Daniel Pally Sandher wrote: You can use Conditions on your Features to set the Level. e.g. Feature Id=MyFeatureA Title=My Feature A Level=1000 Condition Level= ![CDATA[ONLYB]] /Condition ComponentRef Id=MyComponentA Primary=yes/ /Feature Feature Id=MyFeatureB Title=My Feature B Level=2000 ComponentRef Id=MyComponentB Primary=yes/ /Feature If you ran your MSI as msiexec /i myproduct.msi INSTALLELEVEL=2000 ONLYB=true it would only install Feature B as Feature A would have it's Level set to since the public Property ONLYB has a value assigned. Thus to install it for your cases: Only A = msiexec /i myproduct.msi INSTALLELEVEL=1000 A+B= msiexec /i myproduct.msi INSTALLELEVEL=2000 Only B = msiexec /i myproduct.msi INSTALLELEVEL=2000 ONLYB=true Palbinder Sandher Software Deployment and IT Administrator T: +44 (0) 141 945 8500 F: +44 (0) 141 945 8501 http://www.iesve.com **Design, Simulate + Innovate with the Virtual Environment** Integrated Environmental Solutions Limited. Registered in Scotland No. SC151456 Registered Office - Helix Building, West Of Scotland Science Park, Glasgow G20 0SP Email Disclaimer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dschmitz Sent: 11 September 2008 14:29 To: wix-users@lists.sourceforge.net Subject: [WiX-users] MSIEXEC installlevel feature Hello, I'm just wondering if it is possible with MSI and with Wix to have 2 features and to choose via msiexec command line which of the two features should be installed. If I give a feature a Level attribute in Wix msi installs everything with a feature LEVEL = the specified INSTALLLEVEL. But I want to choose exactly one feature, so just equal instead of =. So if I have: A: Configuration 1 LEVEL=1000 B: Configuration 2 LEVEL=2000 I can either install A or A+B but not just B. Does anybody know, if there is another possibility? Thanks Daniel -- View this message in context: http://n2.nabble.com/MSIEXEC-installlevel-feature-tp1082699p1082699.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- View this message in context: http://n2.nabble.com/MSIEXEC-installlevel-feature-tp1082699p1082817.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Problem with SqlDatabase while upgrading
Hi urugan, thanks for your answer. When I uninstall the program via Add/Remove programs the database is removed, so then everything is perfect, so I don't think it is an SQL problem. And to be honest I also don't know where I can check if the SQL works for reinstall. But if I want to upgrade the installed program with msiexec /i wixsetup.msi REINSTALLMODE=vamus REINSTALL=ALL the uninstall routine is not called, I guess just the reinstall will be called, so I have to set the CreateOnReinstall=yes parameter in the SQLDatabase command. But the problem is I can't set that parameter because of the compiler error mentioned in my first post. Is it possible that this is a bug in the current WiX version? But maybe I also didn't understand something correctly, and the problem is somewhere else. Does anybody has further suggestions? Thanks Daniel urugan wrote: I would look at your current database. I think it's more sql problem. Do you have column Attributes? Maybe something prevents dropping db in the firstplace? -- View this message in context: http://n2.nabble.com/Problem-with-SqlDatabase-while-upgrading-tp719783p724326.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Problem with SqlDatabase while upgrading
Hello, While performing a minor upgrade to my wix setup, I want to reinstall my database, all the existing content should be removed. I try to do this with these commands: Component Id=SqlComponent Guid=1234 Sql:SqlDatabase Id=SqlDatabase Database=Foobar User=SQLUser Server=[SQLSERVER],[SQLSERVERPORT] CreateOnInstall=yes DropOnUninstall=yes DropOnReinstall=yes CreateOnReinstall=yes Sql:SqlScript Id=CreateTable BinaryKey=CreateTable ExecuteOnInstall=yes/ /Sql:SqlDatabase /Component But I get the following error: Error 6 Cannot set column 'Attributes' with value 128 because it is greater than the maximum allowed value for this column, 127.candle.exe 0 1 WixSetup Without the DropOnReinstall=yes attribute everything works fine but the msi log file looks like this and the database content is definitely not removed: MSI (s) (E0:E4) [15:20:47:052]: Doing action: UninstallSqlData Action 15:20:47: UninstallSqlData. Configuring SQL Server Action start 15:20:47: UninstallSqlData. MSI (s) (E0:E4) [15:20:47:067]: Creating MSIHANDLE (1) of type 790542 for thread 1764 MSI (s) (E0:F4) [15:20:47:067]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1857.tmp, Entrypoint: UninstallSqlData MSI (s) (E0:10) [15:20:47:067]: Generating random cookie. MSI (s) (E0:10) [15:20:47:067]: Created Custom Action Server with PID 6132 (0x17F4). MSI (s) (E0:98) [15:20:47:114]: Running as a service. MSI (s) (E0:98) [15:20:47:114]: Hello, I'm your 32bit Impersonated custom action server. MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (2) of type 790541 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (3) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (3) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (4) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (4) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (5) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (6) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (6) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (5) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (7) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (7) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (8) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (8) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (9) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (9) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (10) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (11) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Creating MSIHANDLE (12) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (12) of type 790531 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (10) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (11) of type 790540 for thread 5452 MSI (s) (E0!4C) [15:20:47:130]: Closing MSIHANDLE (2) of type 790541 for thread 5452 MSI (s) (E0:F4) [15:20:47:130]: Closing MSIHANDLE (1) of type 790542 for thread 1764 Action ended 15:20:47: UninstallSqlData. Return value 1. I'm using candle.exe version 3.0.4318.0 I would really appreciate if somebody can help me on this issue. Thanks in advance! Daniel -- View this message in context: http://n2.nabble.com/Problem-with-SqlDatabase-while-upgrading-tp719783p719783.html Sent from the wix-users mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users