I am looking at potential issues for when we convert from DTS to SSIS and I am aware that there are some issues with upgrading ActiveX tasks.
The ActiveX connects to an Excel workbook and then loops through each pivot table to refresh the data (there is a query in the workbook that retrieves the data from the database).
Given what I have read elsewhere, I suspect that this will not port directly into SSIS.
What alternatives are there? We could keep it as a SQL2K DTS package task and call that from SSIS but that is only a short term solution. Having done some VB.Net I guess that we could create something using CLR which might not be too difficult/different from what we have now.
Has anybody got any other ideas?
Jez