SQL Server Performance

DTS Task Issue.........

Discussion in 'SQL Server DTS-Related Questions' started by skt680@hotmail.com, Mar 21, 2007.

  1. skt680@hotmail.com New Member

    Hi all,

    I need to know,Is it possible to view sql statement of any executesql task in a DTS package using T-sql ??. we can view Sql statement by DTS graphical tool but i want to see the sql statement or text of any given task by writing T-sql statement.

    Thanks

    Shaurabh
  2. MohammedU New Member

    Negative...

    You can use VB script to get information but not through tsql...


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. skt680@hotmail.com New Member

    MohammedU

    Thanks for your reply

    but I guess, sql statement of a task should be stored somewhere ?? pl suggest
    N if it does store somewhere in sql server So why can`t we access those statements (Any idea..)

    Shaurabh
  4. MohammedU New Member

    All dts information stored in MSDB..sysdtspackages table in PACKAGEDATA column which is HEX code....
    So through TSQL you can't read this information...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page