Skip to Content
author's profile photo Former Member
Former Member

DTS Package Viewer

What is the best method to use to view the DTS package files for BPC NW? I am currently running an older version - Outlooksoft 4.2.

We have various packages that are used during data load processes, etc. My SQL person couldn't figure out how to open them using SQL server.

Could someone list the specific steps to view them in SQL server and / or recommend a DTS package viewer?

Best regards,

Greg

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 01, 2009 at 06:34 PM

    This question was never answered, but I am closing this since the SDN blog doesn't allow a user to have more than 10 open questions at a time. A rule that makes no sense whatsoever.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2009 at 10:46 PM

    Hi,

    Its quite easy to open up a DTS package in SQL 2000 assuming you are using outlooksoft 4.2

    Open up SQL Enterprise Manager

    connect to your database instance

    expand the tree nodes until you see data transformation services

    right click on the data transformation services FOLDER icon

    click Open Package

    voila.

    please note instructions for following this are in the data manager help......

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.