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=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 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
