Unable to edit existing DTS packages

  • I'm very new to SQL Server, so I apologize in advance for being a moron.

    I'm using SQL Server Enterprise Manager (Management Console 1.2 is the only version info I can find), and I need to export data into a txt file and have it run every night. I can create DTS packages by clicking All Tasks --> Export Data, and they show up under "Local Packages".

    If I right click these packages and choose Design Package, I get a "DTS Designer Error: Exception Occurred" popup twice, and then it opens a console with a graphic with "connection 1" and "connection 2" -- but nothing about my query, where it's coming from/going to, any of that.

    Just right clicking under Local Packages and choosing "new package" brings up the same DTS Designer Error although there's a blank screen after that.

    Right clicking under Local Packages and choosing "Package Logs" shows no DTS Packages available on the server, and nothing listed under DTS Package versions and log tree.

    My gut tells me I'm setting these up wrong.

    I'm really hoping this is something simple. I'm also having a (possibly separate) getting the above method to actually say it's scheduled the job every night, but I'll tackle that after figuring out this bit.

    Thanks in advance for your help!

  • - Do you have sufficient permissions to create  package?

    - if you think there is a problem with MMC console throwing an error, can you try registering this server in any other sqlserver EM and try opening the package from there?

  • - I have no idea. I should have permissions for everything. How would I go about checking?

    - How would I do that? Is the MMC like a browser -- that I'm using it to look at the database stuff, and you're saying I should use Firefox instead of IE (for instance)?

  • -its not the browser. you should be opening the enterprise manager (EM) through start>programfiles>ms sqlserver>EM.

    - if you have multiple sql servers then you can open the EM on another server and register this intended server there ( right click on the left pane select new sql server and give the details of this server in the new window)

    - then you can try expanding the server node to dts>local packages and try opening from there

     

  • I know it's not a browser; that was an analogy.

    I think I have multiple servers, but I remote desktop into them to access the databases for the specific applications. Each one of them has the databases listed under "(local) (Windows NT)".

  • sorry... i did not pay attention to the "(for instance)"

    you are right when you remote desktop into another server and open EM, it will show the database on that server under LOCAL...by default. here you can register the intended server and look at the db items of that.

    once you register the target server here it should look like this

     

    +Local  ( expand this to see the db items of this server)

    +<intended server name> (expand this to see db items of the target server)

     

    you can refer to BOL for more details on registering servers in EM

  • Thanks. I've escalated it to My People -- I'm discovering further problems that seem to indicate the server is misconfigured, or needs higher level kicking than I can administer.

    I appreciate your help, and will certainly be back for more guidance in the future!!

Viewing 7 posts - 1 through 6 (of 6 total)

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