Post reply

Error in Execute SQL Task

  • October 22, 2010 at 7:50 am

    #388078

    Hi Everybody,

    I am trying to execute a simple select query in execute sql task

    SELECT

    MAX(ASOF_YYYYMM)

    FROM BHKP.AU_REF

    Basically this getting max of a column YYYYMM from table AU_Ref from database BHKP. This BHKP is a Teradata DB. And I am connecting this through ADO.NET (.NET provider for Teradata)

    Well this connection work perfectly fine with the Dataflow task just above this SQL task.

    The error I am getting when I try to parse the query is -- Object reference not set to an instance of an object

    When I run the Task it gives me error at the output window is --

    Error: 0xC0024104 at Execute SQL Task 1: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter.

    Task failed: Execute SQL Task 1

  • October 22, 2010 at 8:32 am

    #1240958

    Hi

    What is the Version u are using ?

    This problem occurs because of memory utilization after you install SQL Server 2005 SP2. When you use SMO to generate SQL scripts, the task uses lots of memory. When the operating system cannot provide sufficient memory, you may experience this problem.

    Thanks

    Parthi

    Thanks
    Parthi

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

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