Post reply

error when trying to access dts from my client enterprise manager

  • January 25, 2007 at 10:09 am

    #68181

    hi i have the client enterprise install in my computer, i am trying to change a dts by enterprise manager but i keep getting an error

     

    error source: Microsoft data transformation services (DTS) package

    error description: unspecified error

     

    but when i got to the server and i try to open it i get no errors, any idea why this is happening? this is the only dts in which i am having problems with the other one i could access just fine.

  • January 25, 2007 at 10:52 am

    #685637

    When, exactly, do you get this error?  Opening the package, running it, or trying to save it?

  • January 25, 2007 at 12:33 pm

    #685671

    when i go to enterprise manager (via my desktop) , go to data tranformation services, local packages, go to my dts, right click , design package...

    and this only happens with this dts the other one i could open just fine as i said before...

    in my server box i could open the dts just fine.

    any advice please??

     

  • January 25, 2007 at 9:02 pm

    #685743

    Make sure the Client Tools on your workstation are at the same service pack level as your server.

    Andy

  • January 26, 2007 at 7:28 am

    #685819

    i ran:

     SELECT @@VERSION

    GO

    in my query analyzer in my worstation and got this

    Microsoft SQL Server 2000-8.00.2039 and i got the same when i ran it in the server.

  • January 26, 2007 at 7:40 am

    #685825

    Is it possible that one of the data conections on your server does not exist on your remote machine?  For example, your server may have a DSN to some computer and this particular package may be calling this data.  If your workstation does not have the same dsn, it may not be capable of editing the package.

    This is just a wild stab in the dark but, one never knows.

    Please post back when you fix it and let us know what happens. 

     

    Kindest Regards,

    Ginger

    Delete * Where flatfile=true

  • January 26, 2007 at 8:39 am

    #685857

    It may help to know more about the package, but so far the places to start have been covered.

    - service packs need to be the same (and you have already checked that)

    - as said in the last post, make sure any resources used by the package exist on the workstation (a reference to the C drive from the package looks at the local C drive on whatever machine you open the package from - not the server)

    - if this yields nothing, save the package as a file on the server, copy the package to your workstation and open it from the file - this often gives better error messages if there is a problem

  • January 26, 2007 at 9:17 am

    #685873

    how do i save the package as a file on the server?

  • January 26, 2007 at 10:11 am

    #685892

     

    >>how do i save the package as a file on the server?

    1. Open Package

    2. Package -> Save As

    Look at the options available in the drop downs

    Kindest Regards,

    Ginger

    Delete * Where flatfile=true

  • January 26, 2007 at 10:50 am

    #685903

    thank you i did it and save it and changed the conection to say instead of "local" to the name of my sql server and now the dts works! thanks!

  • January 26, 2007 at 2:00 pm

    #685963

    SELECT @@VERSION will always return the version of the server to which you are connected. It will not tell you the version of your client tools. I no longer have any versions of SQL 2000 installed anywhere, but you can probably see the version of your Enterprise Manager by clicking Help --> About...

    Version 8.00.2039 is Service Pack 4.

    This is most likely the problem. Service Pack 3 clients can not open Service Pack 4 DTS packages. The Service Pack needs to be run on machines that have only the client tools also.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 11 posts - 1 through 10 (of 10 total)

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