Post reply

DTS Query Designer Error

  • November 7, 2003 at 6:59 am

    #107406

    Hello everyone,

    I wrote a query in DTS Query Designer and I'm receiving the following error:

    The Query Designer does not support

    the SET STATEMENT SQL construct.

    Now, this very same code will execute in SQL Query Analyzer.

    Does anyone have any suggestions?

    Thank you,

    Peter

    Peter M. Florenzano

    Database Administrator

  • November 7, 2003 at 7:11 am

    #481237

    Also,

    I forgot to mention that I'm receiving errors on my GOTO statements too. And like the other error, this code works in SQL Query Analyzer.

    Peter

    Peter M. Florenzano

    Database Administrator

  • November 7, 2003 at 8:06 am

    #481263

    What kind of task are you using?

    SQL Task.

    If the SQL works in the query analyzer,

    maybe you can put the code in a stored procedure and call that procedure from the DTS package

  • November 7, 2003 at 8:12 am

    #481267

    I'm using the Execute SQL Task

    Peter M. Florenzano

    Database Administrator

  • November 10, 2003 at 8:30 am

    #481430

    I have used it in all forms

    Set ansi null on

    update employees

    set name = ''

    and

    set @name = 'max'

    It should work

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

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