Post reply

script task and DTS object

  • April 12, 2009 at 9:09 am

    #199123

    i want to write code for a "script task" in SSIS in sql2008

    the thing is that when i want to add code like in this example :

    http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008--ssis-data-profiling-task/ (in the middle of the page)

    i get the error :

    Dts.TaskResult=......

    and the error :

    Reference to a non-shared member requires an object reference.

    any idea why?

    Thanks

    Peleg

  • April 13, 2009 at 3:16 am

    #976429

    check with the references u have added

  • April 13, 2009 at 3:50 am

    #976438

    arulmanicse (4/13/2009)

    check with the references u have added

    what do you mean by that?

  • April 13, 2009 at 4:03 am

    #976443

    You cannot use the class name itself to qualify a member that is not shared. The instance must first be declared as an object variable and then referenced by the variable name.

    To correct this error

    Declare the instance as an object variable.

    Reference the instance by the variable name.

  • April 13, 2009 at 4:50 am

    #976456

    so where is the mistake in the code i have copied from the link above,with the example?

    can you give code example?

  • April 13, 2009 at 8:31 am

    #976641

    by the way : how can i debug a script task?

    ok : the problem is that you cant debug on 64bit machine

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

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