[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-04-29
Medium Priority
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

ID: 35490367
What type of help you need?

Accepted Solution

Kalyanum Deepak Kumar earned 668 total points
ID: 35490371
Hi dileep,
1) DTS is not related to SQL Server 2005 rather it is related to SQL Server 2000.
2) Check http://msdn.microsoft.com/en-us/library/cc917688.aspx. 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
Bhavesh Shah earned 664 total points
ID: 35490459

Assisted Solution

radcaesar earned 668 total points
ID: 35490864
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

ID: 35773285
Thx Experts.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

873 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