Post reply

Viewing the SQL from Execute SQL Task

  • July 14, 2006 at 10:37 am

    #171591

    Hi,

    I have an execute SQL Task that takes 3 parameters and runs without errors but doesn't do what I expect it to. If I run an identical SQL statement in Management Studio it works as I expect. So, the parameters must generate a statement that is valid but it would appear that the parameters are amended, somehow. So, I'd like to be able to see the SQL that the task actually sends to the database. Is it possible to do this?

    As another test, I built a variable that was evaulated as an expression that took the main part of the SQL and used the variables I'd used previously and this worked in the same way as the SQL in Management Studio.

    Any ideas?

    Thanks.

  • July 14, 2006 at 1:24 pm

    #649363

    You should probably try running SQL Profiler and capture what's being passed in by the SSIS package.  That'll give you a good idea of what the system is doing.

  • July 17, 2006 at 2:02 am

    #649469

    Thanks for that. It gave me just what I was after.

    Ian

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

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