Need Quick help to study DTS using with Microsoft SQL Server 2005.

Posted on 2011-04-29
Last Modified: 2012-05-11
Hi Experts,

Needs to study about Micorsoft SQL Server DTS Package, Could you please help me with this. I am going to take the support of a Dotnet Windows application. This application is making use of Dotnet 2.0, SQL Server 2005 and DTS Package. I have around 11 years of experiece in Micorosft technologies, but didn't get a chance to work with DTS so far.

Can you help me with this?

Question by:dileepav

    Expert Comment

    What type of help you need?
    LVL 4

    Accepted Solution

    Hi dileep,
    1) DTS is not related to SQL Server 2005 rather it is related to SQL Server 2000.
    2) Check This can give you the overview what is DTS and tasks related to it.
    3) Basically, DTS is an Extract,Transform,Load tool which can be customized in a large way using different tasks in DTS.
    4) The latest version of DTS is SSIS in SQL Server 2005,2008,2008R2 which has more powerful integration with .NET CLR ans much more flexible than DTS.

    LVL 19

    Assisted Solution

    by:Bhavesh Shah
    LVL 9

    Assisted Solution

    I believe you are talking about SSIS (DTS was renamed in 2005). Since you have enough experience in .NET its not too hard to program SSIS, But you should have some basic knowledge on ETL concepts. There were tons of tutors and BLOGS in web over there for SSIS particularly MSDN portal from MS.

    Go ahead, If you find any interruptions, we are here to help you.

    Author Closing Comment

    Thx Experts.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how the fundamental information of how to create a table.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now