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=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 > > -- View this message in context: http://n2.nabble.com/Wix---integrating-Microsoft-SSIS-package-into-setup-tp2240080p2268325.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ 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
