Can't find SSIS

Posted on 2007-08-01
Last Modified: 2012-06-21
I loaded SQL SErver 2005 and SP2 but I am not seeing how to get to the SSIS for DTS.  Am I over looking or do I need to add something else?
Question by:LiCann
    LVL 51

    Accepted Solution

    LVL 42

    Expert Comment

    if you installed
    SQL Server Management Studio
    SQL Server Business Intelligence Development Studio
    "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

    SQL Server Management Studio->file-> connect object explorer->from pop-up login form select "integration servces" from combobox services...

    also you can see ssis pack by using
    dtexecui.exe util
    --during creation sqlagent job if in step properties select type ssis pack

    LVL 51

    Expert Comment

    Upon rereading your question I noticed an issue.  You mentioned "SSIS for DTS".  SSIS has the same purpose as DTS but it is completely different technology.  If you have older DTS packages you can either rewrite them as SSIS packages OR install the feature pack I gave you the link for and then run both DTS and SSIS packages.
    LVL 42

    Assisted Solution

    one ,ore:
    <how to get to the SSIS for DTS.  >
    .. you'll need to install the SQL Server 2005 Feature Pack (specifically, the Package Designer for 2000) to modify the package after the upgrade.
    Upgrading SQL Server 2000 DTS Packages to SSIS

    Author Comment

    I tried to go in this way>

    SQL Server Management Studio->file-> connect object explorer->from pop-up login form select "integration servces" from combobox services...

    but failed - do I need permissions?

    LVL 42

    Expert Comment


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now