Excel 2003 Automation
I cannot find an explantion on how to configure SSIS so it can execute Excel 2003 automation.
My goal is to update an Excel 2003 spreadsheet with SQL Server 2005 data using an SSIS package having a Script Task that utilizes Excel automation.
I've discovered in SQL Server 2005 BOL that, "
The.NET tab of theAdd Reference dialog box in Microsoft Visual Studio for Applications lists the managed assemblies found in the%windir%\Microsoft.NET\Framework\v2.0.xxxxx folder and the %ProgramFiles%\Microsoft SQL Server\90\SDK\Assemblies folder. Therefore, by default, this list is largely limited to assemblies from the Microsoft .NET Framework class library and assemblies installed by SQL Server 2005. The contents of the list are determined exclusively by file location and not by installation in the global assembly cache (GAC) or by other assembly attributes or properties. As a result, a copy of any assembly that you want to reference needs to be present in one of the specified folders. TheAdd Reference dialog box in VSA does not include theBrowse button that is present in Microsoft Visual Studio for locating and referencing managed assemblies in other folders, and does not include theCOM tab for referencing COM components.
A custom assembly that you want to use in the Script task or the Script component must also be signed with a strong name and installed in the global assembly cache."
I tried to "gacutil" Excel.exe into one of the above folders only to be told that "The module was expected to contain an assembly manifest."
Any insight appreciated,
Mark Holahan
