Post reply

DTS error when executed from SQL Server 2005

  • May 28, 2007 at 6:24 am

    #69820

    Hi,

    I have this DTS trying to execute a couple of Execute SQL  tasks and tranfer of data. Ever since SQL Server 2005 has been installed this package fails with the error: No such interface supported.

    Logs read thus:

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnError:  DTSStep_DTSExecuteSQLTask_1, Error = -2147220421 (8004043B)

       Error string:  The task reported failure on execution.

       Error source:  Microsoft Data Transformation Services (DTS) Package

       Help file:  sqldts80.hlp

       Help context:  1100

     

    Error Detail Records:

     

    Error:  -2147220421 (8004043B); Provider Error:  0 (0)

       Error string:  The task reported failure on execution.

       Error source:  Microsoft Data Transformation Services (DTS) Package

       Help file:  sqldts80.hlp

       Help context:  1100

     

     

    Error:  -2147467262 (80004002); Provider Error:  0 (0)

       Error string:  No such interface supported

       Error source:  Microsoft OLE DB Provider for SQL Server

       Help file: 

       Help context:  0

     

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart:  DTSStep_DTSSendMailTask_5

    DTSRun OnFinish:  DTSStep_DTSSendMailTask_5

     

    Both SQLServer2005_BC.msi and SQLServer2005_DTS.msi is installed. All other packages after the upgrade seems to be working.

    Any help is appreciated.

    Thanks,

    Raghu G

  • June 1, 2007 at 2:39 am

    #710248

    Can you post the SQL code for the ExecuteSqlTask that is failing?


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

  • June 2, 2007 at 1:51 am

    #710465

    Apologies for not sending the code earlier. However i have come over that. The error was because a DTS, when run through SQL Server 2005 does not support assigning TEXT data to global variable. The same was supported in SQL Server 2000

  • June 2, 2007 at 1:52 am

    #710466

    By TEXT data i mean data type TEXT

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

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