SQL Server Performance

Unspecified error

Discussion in 'SQL Server DTS-Related Questions' started by shan, Apr 3, 2007.

  1. shan New Member

    I am trying to save a existing DTS with just a parameter change to one of the Stored Procedure and when i tried to save it, its giving "Unspecified error". It does not give me any error number.

    Environment: SQL 2000
    Permission: SA
    About Package: It gets Raw data files and loads in to the tables and couple of other SP's executed after the data load (i really don’t know the business logic behind it), the only change which im doing is changing its parameter from 2006 to 2007.

    When i try to save the package or reopen the packing it gives "Error Unspecified".

    Will the package get corrupted? Package is stored in MSDB , If so how do I fix it.

    Pls advise me...

    I checked the SQL error log and nothing specific shows up....

    Thanks
  2. MohammedU New Member

    Is the package created on different SP server?

    FIX: DTS packages fail with an unspecified error on a computer that is running Windows XP Service Pack 2
    http://support.microsoft.com/kb/890841


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. shan New Member

    I just found out that if the DTS job contains FTP item and if any one else other than the owner of the job tries to access the DTS Package, it gets corruped and give "Unspecified error", If i remove off the FTP item then the package is just fine...

    I searched a lot in the Microsoft site if there is a fix for this but could not find any..

    Pls post if you have any solution for this...
  4. satya Moderator

    http://www.sqlteam.com/item.asp?ItemID=12408
    http://vyaskn.tripod.com/sql_server_dts_best_practices.htm

    Specify what kind of operations you are performing with FTP under that DTS package. Also ensure the privileges associated to SQLagent are enough to run that FTP task under DTS package.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page