Posted on 2009-04-20
Last Modified: 2012-05-06

I am new to SQL 2005, I have been using DTS in SQL 2000.  My question is,

1. How can I upgrade DTS package from 2000 to 2005
2. Where can I create a new SSIS

Question by:mcrmg
    LVL 8

    Accepted Solution

    Question 2.
    You use SQL Server Business Inteligence Development Studio, in SQL Server 2005 folder on start menu. Click new project and select Integration Services project.  
    LVL 8

    Assisted Solution


    Author Comment

    if I need to buy a book for this, do you have any suggestion?  thx

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    779 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

    12 Experts available now in Live!

    Get 1:1 Help Now