How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005? I need to automate Excel for formatting.
Thank you.
Dan
Adding refereneces to external assembleis is documented in Books Online -
Referencing Other Assemblies in Scripting Solutions
http://technet.microsoft.com/en-us/library/ms136007.aspx
For Office applications like Excel that are COM, you will need to download the PIAs if you have not already.You will need to reference the PIA.
Download - http://www.microsoft.com/downloads/details.aspx?FamilyID=3C9A983A-AC14-4125-8BA0-D36D67E0F4AD&displaylang=en
General page of on PIAs if you are not familar already - http://msdn2.microsoft.com/en-us/library/aax7sdch.aspx
