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=node&node=2240268&i=0> ] Sent: Thursday, January 29, 2009 09:14 To: wix-us...@... <http://n2.nabble.com/user/SendEmail.jtp?type=node&node=2240268&i=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=node&node=2240268&i=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=node&node=2240268&i=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
