Post reply

DTS to SSIS ActiveX task conversion

  • March 25, 2008 at 9:17 am

    #128388

    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

  • March 25, 2008 at 9:29 am

    #793585

    I'm in favor of porting your code. I think that the main code you will need to change is how you instantiate the workbook. But the rest of the code related to the Excel spreadsheet should work. You would want to dim the variables with the appropriate types.

    Russel Loski, MCSE Business Intelligence, Data Platform

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply