Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Ireland
    Posts
    54

    Unanswered: DTS Error ? No query specification returned by transform status

    I'm getting this error in a simple DTS package.

    No query specification returned by transform status.

    Any ideas what's causing this ?

    DTS is simply running a query (which returns data via preview)
    and insert results into a table.

    Thanks
    Mark

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try to redefine the package and run.
    Ensure the account used is having required privilege to insert the data.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •