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 21 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy