We have a current SSIS package which uses an OLE connection object to connect to our SQL Server database. We also have DQS installed on the same server and have written a DQS Cleansing task in SSIS which works nicely.
If we deploy this to a different environment (e.g. Staging) the OLE connection is set by a parameter in the job which runs the SSIS package. Is it possible to do something in a script task which will set the DQS Connection to use the same server
without having to change it manually?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.