Post reply

VSTA script issue to retrieve schema information with OLE DB and DataTable

  • September 8, 2009 at 5:14 pm

    #138686

    Good Day Everyone,

    I would like to test the presence of a table in an MS-Access target database, for which I defined an OLE DB Connection in my SSIS project.

    But I cannot declare (nor instantiate obviously) any "DataTable", apparently because of some missing Reference. Here is the message I receive in Visual Studio for Application.

    Using the "Imports System.Xml" directive does not correct the situation...

    When I try to run the same code in Visual Studio 2005, I do not receive this message - is there any chance I could have it run on VSTA?

    Why is that so that I receive this message?

    Would you recommend another workaround to achieve my goal?

    Thanks in advance for your time and precious help,

    @+ JP

  • September 9, 2009 at 6:54 am

    #1051032

    You have to Add Reference to System.Xml library. The command is somewhere in the Project menu.

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

  • September 9, 2009 at 9:37 am

    #1051230

    Thank you CozyRoc,

    I am sorry but I cannot find 'add references' under 'Project' in Visual Studio 2005.

    Take care, @+ JP

  • September 9, 2009 at 9:47 am

    #1051241

    You have to open the script in edit mode and look for Add Reference command there.

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

  • September 9, 2009 at 9:54 am

    #1051245

    You 'Roc' - I really doubted getting an answer here.

    I better understand the behavior of SSIS. Thanks a bunch once again.

    @+ JP

Viewing 5 posts - 1 through 4 (of 4 total)

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