If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Drag the Excel Source to the Data Flow window and configure it to access your Excel Source file.
Now drag the OLE DB Source to the same window and configure it to access your “Emp” table from the Database.
The city and state information will be extracted from the Adventure Works DW database and output to an Excel spreadsheet.
The sales department could use this spreadsheet to enter the forecast.
A good scribe with a lot of patience should have changed by hand all the connections by double-clicking the HLP Connection Manager of each package, and then changing the referenced server/database: Not being endowed with such virtues :) I took just a little of time to write a small script in Power Shell, using the fact that a SSIS package (a I don’t enter into the details of each cmdlet used. Alternatively, you can use a specific object model exposed in some .