Post reply

Need help with Script task vs ActiveX task

  • August 23, 2011 at 7:54 am

    #256058

    I'm rewriting a DTS package in SSIS 2008 R2 64bit. The DTS package ran an ActiveX vbs script to query the Active Directory. In SSIS I tried an ActiveX Script Task and got an error message that research says I must install the "Runtime Support for DTS Packages". So I tried a script task instead. I click Edit Script, the editor opens, I post my code where it says to and now have a ScriptMain.vb. But when I close the editor it is not part of my SSIS project. How do I get the ScriptMain.vb into my SSIS package? And is this the better/correct option? Would I be better served installing the Runtime Support for DTS Packages?

    Thanks all.

  • August 23, 2011 at 8:14 am

    #1372029

    I think I had only pasted the code and saved. Did not try and Build. Tried to Build and got all kinds of errors... and that's because my code is not VB, its VBS. Looks like my only option is to get the ActiveX script taks working.

  • August 24, 2011 at 9:49 am

    #1372684

    Hi Randy,

    Another option would be for you to learn VB.NET programming and implement your script using the .NET framework. VBS is very different animal compared to VB.NET.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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