I am working with a new machine with windows 7 in SSIS . When I opened a script task in one of my packages that exports and formats data to a excel i received error. Validation error. Script Task : The task is configured to pre-compile the script,
but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.
Clicking the Design script button didnt help
I assume I need to re-add the reference to the PIA's but now I am not sure where to find them. I also have had vs 2008 removed and added vs2010 express, but I develop the packages in bids for sql server 2005
another error i get in the scrip its self is " XlHAlign not declared"
Where do I find microsoft.office.interop.excell.dll in particular?
View Complete Post