August 25, 2004 at 9:14 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/
January 24, 2005 at 6:58 am
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.
January 24, 2005 at 7:05 am
Thanks Sameer. Nice to see you liked the article.
Others, your comments are welcome.
Vinod Kumar
July 7, 2005 at 7:14 pm
Hi Vinod
The screen shots might need to be changed, as thos product is now called SSIS and not DTS
Thanks
PP
paul
September 28, 2005 at 3:35 am
February 10, 2006 at 8:47 am
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.
February 13, 2006 at 7:10 am
It is an important artical. Yet, it is written mostly for someone that olready know the components.
Amos
February 14, 2006 at 4:30 pm
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.
February 1, 2008 at 5:22 am
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.
February 1, 2008 at 8:01 am
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.
February 1, 2008 at 10:41 am
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.
Greg
February 1, 2008 at 10:45 am
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
February 1, 2008 at 1:43 pm
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.
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
February 4, 2008 at 9:06 am
mtassin (2/1/2008)
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
but I would like to occasionally make new DTS packages and not just edit old ones.
It sounded like you had old DTS packages.
Greg
February 4, 2008 at 9:38 am
mtassin (2/1/2008)
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
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
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply