Post reply

DTS, dynamic task error

  • March 15, 2007 at 3:40 pm

    #69882

    I got this error:

    "The SQL statement IS VALID."

    when defining subject line for for Send email task via dynamic properties.

    Query:

    select 'Unmatched results as of ('   + convert(varchar(30), getdate())+ ').

    Any ideas why valid SQL is an error in this case or it means something else?

     

  • March 16, 2007 at 9:11 am

    #695496

    the select statement, you had a '.' instead of ' at the end.

    select 'Unmatched results as of (' + convert(varchar(30), getdate()) + ')'

  • March 16, 2007 at 10:10 am

    #695507

    "." was added when cut-and-paste into forum. Statement runs OK, no problem. I does what I need.

    Why MS shows it as error. READ error message I have send

    "The SQL statement IS VALID"

  • March 19, 2007 at 3:28 pm

    #695822

    I used dynamic task and it populated the subject line fine.

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

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