none
Does SSIS 2008 support ActiveX script in VB script language?

    Question

  • Hi,

    I am using Sql server 2008. In my SSIS package, I am using ActiveX script component written in Visual Basic script. If I execute the package means I am getting the following error.

    "An error occurred while adding the managed SSIS type library to the script host. Verify that the DTS 2000 runtime is installed

    Error at ActiveX Script Task : There were errors during task validation"

    Can anyone please help me to fix the issue?

    Thursday, September 13, 2012 2:18 PM

Answers

All replies

  • No, not really.

    You should rewrite this ActiveX script as a Script Task

    Thursday, September 13, 2012 2:20 PM
  • ActiveX scripts are supported in SSIS 2008, but not in 2012. E.g. you cannot migrate them.

    Based on what I understood you tried to open a package somebody else created, but your machine does not have the DTS (SQL Server 2000) backward compatibility component installed. So just go get it and you will then be able to open it.


    Arthur My Blog

    Thursday, September 13, 2012 2:23 PM
    Moderator
  • Install DTS support. Check this.

    http://btsbee.wordpress.com/

    Thursday, September 13, 2012 2:23 PM
  • Thanks for your Suggestions Arthur.

    I just want to migrate my SSIS 2005 packages to SSIS 2008 version. I am just getting stuck in the ActiveX script part. When i copy my VB script from SSIS 2005 to SSIS 2008, i am getting the above error. Can you please guide me how to proceed further.

    Thursday, September 13, 2012 2:35 PM
  • The best will be to rewrite them into the regular Script Tasks

    Arthur My Blog

    Thursday, September 13, 2012 2:37 PM
    Moderator
  • Thanks for your Suggestions Christa.

    I am just confused. I am having ActiveX Script task in SSIS 2008, then why should i rewrite my code as a Script task.

    I just want to migrate my SSIS 2005 packages to SSIS 2008 version. I am just getting stuck in the ActiveX script part. When i copy my VB script from SSIS 2005 to SSIS 2008, i am getting the above error. Can you please clarify my doubts and guide me how to proceed further.

    Thursday, September 13, 2012 2:39 PM
  • I am just confused. I am having ActiveX Script task in SSIS 2008, then why should i rewrite my code as a Script task? Can you please clarify me...

    And also in Script task, I have to convert my VB script to vb.net or C# right? Or is there any other options availabe?

    • Edited by Sam8939 Thursday, September 13, 2012 2:44 PM
    Thursday, September 13, 2012 2:42 PM
  • Yes, VB or C# .Net language is supported in SSIS 2008 Script Task

    Arthur My Blog

    • Marked as answer by Eileen Zhao Thursday, September 20, 2012 2:34 PM
    Thursday, September 13, 2012 2:49 PM
    Moderator
  • besides, I think the error you get is because your new machine where SSIS 2008 is a 64 machine (you used SSIS 2005 on another, and did not tell us?).

    Arthur My Blog

    Thursday, September 13, 2012 3:04 PM
    Moderator