SQLServerCentral / Discuss Content Posted by Vinod Kumar / Article Discussions / Article Discussions by Author / Introduction to DTS in SQL Server 2005 / Latest Posts

RE: Introduction to DTS in SQL Server 2005

Jaago — Wed, 20 Jun 2012 09:39:28 GMT

RE: Introduction to DTS in SQL Server 2005

StefanJ — Tue, 15 Sep 2009 06:31:59 GMT

First time I have used 2005. Trying to follow the article but am stuck at the first hurdle.'Data Transformation Services' does not appear in my list of templates. See screen print.

RE: Introduction to DTS in SQL Server 2005

nico van niekerk — Wed, 10 Sep 2008 16:13:30 GMT

Pity it was poorly written, had wrong references, skipped steps, and assumed that the reader knows all the missing steps.

RE: Introduction to DTS in SQL Server 2005

SQLNewbie-610691 — Sat, 01 Mar 2008 11:36:57 GMT

Hi Greg,I read your comment and I would like to try it..." create a new DTS package in SSMS by opening an existing legacy DTS package and saving it with a new name. Then, open the new package and replace what's in it with whatever you want in the new package."We have an existing DTS package in SQLPRODUCTION , I would like copy and modify it to SQLTEST using SQL Server Management Studio. I downloaded Design-time Support for SQL Server 2000 DTS Packages.I'm new in SQL Server 2005, can you tell me the steps on how to do this?Thanks,M

RE: Introduction to DTS in SQL Server 2005

Mayur-370463 — Thu, 07 Feb 2008 22:57:34 GMT

hi vinodh,its really appreciatable work u done

RE: Introduction to DTS in SQL Server 2005

Sreejithsql — Mon, 04 Feb 2008 16:21:02 GMT

hi vinodh,its really appreciatable work u done.nice presenatation.i like ur work well. like this any articles means pls present.thxsreejithMCAD

RE: Introduction to DTS in SQL Server 2005

Tom Garth — Mon, 04 Feb 2008 09:38:20 GMT

[quote][b]mtassin (2/1/2008)[/b][hr]Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/[/quote]Do you mean that you don't have access to a single SQL 2k instance? Then why don't you install one, complete with sample DBs, and create a couple of templates to work with?Tom Garth

RE: Introduction to DTS in SQL Server 2005

Greg Charles — Mon, 04 Feb 2008 09:06:05 GMT

[quote][b]mtassin (2/1/2008)[/b][hr]Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/[/quote][quote]but I would like to occasionally make new DTS packages and not just edit old ones. [/quote]It sounded like you had old DTS packages.

RE: Introduction to DTS in SQL Server 2005

Tom Garth — Fri, 01 Feb 2008 13:43:05 GMT

[quote]Maybe for a programmer SSIS is a big improvement over DTS, but for a normal user who just wants to dump the data from a table, it's overly complicated.[/quote]I am a Programmer, and have worked with VS for many years. My impression is no different than yours. 'Overly complicated' is a polite way of describing it. I'll keep using DTS for as long as it's supported.Tom Garth

RE: Introduction to DTS in SQL Server 2005

mtassin — Fri, 01 Feb 2008 10:45:06 GMT

Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/

RE: Introduction to DTS in SQL Server 2005

Greg Charles — Fri, 01 Feb 2008 10:41:06 GMT

Heh, don't tell anyone, ;) but you can create a new DTS package in SSMS by opening an existing legacy DTS package and saving it with a new name. Then, open the new package and replace what's in it with whatever you want in the new package.

RE: Introduction to DTS in SQL Server 2005

mtassin — Fri, 01 Feb 2008 08:01:16 GMT

I have to agree... Things I used to know how to do in DTS I find to be a major chore in SSIS. I miss DTS... Would have been happier if they had fully supported both. DTS for the simple stuff... SSIS when you need the raw muscle.I know I can download the DTS designer component for SQL 2K5... but I would like to occasionally make new DTS packages and not just edit old ones.

RE: Introduction to DTS in SQL Server 2005

garymastin — Fri, 01 Feb 2008 05:22:39 GMT

Maybe for a programmer SSIS is a big improvement over DTS, but for a normal user who just wants to dump the data from a table, it's overly complicated.

RE: Introduction to DTS in SQL Server 2005

Suresh Kumar Maganti — Tue, 14 Feb 2006 16:30:00 GMT

In The article, the "Raw File Source" may need to be replaced with "Flat File Source". If I copy the content form event viewer to a text file and designate it as a "Raw File Source" in the Data Flow Diagram, SSIS gives an error. However the same text file works fine when designated as a "Flat File Source". In fact, you have mentioned it as a "Flat File Source" in the diagram in your example but in the paragraph above the diagram, you have mentioned it as "Raw File Source". May be it's a typo. However, the article is great, very informative and to-the-point. Great work.

RE: Introduction to DTS in SQL Server 2005

Amos Baranes — Mon, 13 Feb 2006 07:10:00 GMT

It is an important artical. Yet, it is written mostly for someone that olready know the components.

Amos

RE: Introduction to DTS in SQL Server 2005

Rasool Omidakhsh — Fri, 10 Feb 2006 08:47:00 GMT

I agree with Sudheer, Its been a long time since Microsoft change the name to SSIS (In Beta 2 may be even late beta 1). So to show screen shots that no longer exist is a bit misleading for some folks.

RE: Introduction to DTS in SQL Server 2005

cutespn — Wed, 28 Sep 2005 03:35:00 GMT

Vinod,

Good work :-). Its better to update the screenshots which refer to the name "DTS", as now there is nothing called DTS in SQL Server 2005, as you know its SSIS. I felt this change needs to be done, coz it might be confusing to a newbie.

Cheers..

RE: Introduction to DTS in SQL Server 2005

sqlemail@yahoo.com — Thu, 07 Jul 2005 19:14:00 GMT

Hi Vinod

The screen shots might need to be changed, as thos product is now called SSIS and not DTS

Thanks

RE: Introduction to DTS in SQL Server 2005

Vinod Kumar — Mon, 24 Jan 2005 07:05:00 GMT

Thanks Sameer. Nice to see you liked the article.

Others, your comments are welcome.

Vinod Kumar

RE: Introduction to DTS in SQL Server 2005

Sameer Dehalvi — Mon, 24 Jan 2005 06:58:00 GMT

An Excellent article. There is no way to struggle for any material. Artical is well formatted, well written with screen shots. Great work.

Thanx,

Sameer Dehalvi.

Introduction to DTS in SQL Server 2005

Vinod Kumar — Wed, 25 Aug 2004 21:14:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/